Şu kategorideki gönderiler: Analysis Services

Announcing support for backup and restore of Power BI datasets

e are excited to announce the public preview of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). You can now use SQL Server Management Studio (SSMS), Analysis Services cmdlets for PowerShell, and other tools to perform backup and restore operations in Power BI via XMLA endpoints in much the same way as you would for tabular models in Azure Analysis Services (Azure AS).

» Devamını okuyun

Community and third-party tools for developing enterprise-level Power BI and Analysis Services models

Over the past few years, along with the high adoption rate of Power BI, also came the development of new tools by the Power BI community. Customers, partners, and individual users are contributing tools that improve the productivity of users creating models and reports in Power BI. It’s an evolution of a trend that started several years ago with tools that support developers using Analysis Services as a backend platform for their enterprise Business Intelligence solutions.

» Devamını okuyun

Using XMLA endpoints to change data sources in a Power BI dataset

The purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server Analysis Services maintain these settings in the data model.

» Devamını okuyun

Moving on-premises AS and RS BI solutions to Azure – and closer to Power BI

With the availability of virtual machine images for SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in Azure Marketplace, you can now more easily migrate your AS and RS BI solutions from on-premises to Azure! This is a great opportunity to move your multidimensional workloads closer to Power BI to reduce the physical distance between your AS servers and your Power BI reports. For the same reasons, it’s also a good idea to deploy Azure VMs running SSRS in the same region as your SSAS VMs, or to migrate your paginated reports to Power BI so that your reports have the most efficient connectivity to their data models.

» Devamını okuyun