Best practice rules to improve your model’s performance
Want to improve the performance and design of your Power BI model? Run these newly published rules against your model to quickly identify areas of improvement!
» Read morePosts tagged: Analysis Services
Announcing the general availability of read/write XMLA endpoints in Power BI Premium
General announcement of read/write XMLA endpoints in Power BI Premium. List of client tools that natively work with Power BI Premium.
» Read moreDirectQuery for Power BI datasets and Azure Analysis Services (preview)
In Nov 2018, we released composite models, which allow you to seamlessly add multiple DirectQuery sources and imported data to your models. We have heard your feedback that you would like to do this with sources you previously live connected to, like Power BI datasets and Azure Analysis Services sources. We are excited to announce that DirectQuery for Power BI datasets and Azure Analysis Services is now in preview! This long-awaited addition allows report authors to use DirectQuery to connect to Azure Analysis Services or Power BI Datasets as sources in combination with other DirectQuery and imported data
» Read moreMoving 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.
» Read moreAnnouncing improved MDX query performance in Power BI
With a recent update of the Analysis Services Tabular engine in Power BI, Multidimensional Expressions (MDX) clients, such as Microsoft Excel, can now enjoy improved query performance against datasets in Power BI.
» Read moreAnnouncing public preview of external tools in Power BI Desktop
Today, we are further enabling external tools to work with Power BI datasets, this time from within the Power BI Desktop authoring experience. We are excited to announce the public preview of external tool support in Power BI Desktop.
» Read moreAnnouncing support for service principals using the XMLA endpoint in Power BI Premium
In Power BI, you can now use service principals to automate common tasks such as deploying models, performing a data refresh, and applying model changes. Permissions are assigned to service principals through workspace membership, much like regular user accounts.
» Read morePower BI Service and Mobile February and March 2020 feature summary
It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of February and March.
» Read moreAnnouncing read/write XMLA endpoints in Power BI Premium public preview
We are excited to announce the public preview of read/write capabilities for the XMLA endpoint in Power BI Premium.
» Read morePower BI Premium and Azure Analysis Services
Puzzled when to use Power BI Premium vs Azure Analysis Services? Power BI Premium is where future investments will be made but there are things to consider when making a choice.
» Read more