We are excited to announce the initial release of a query performance optimization aimed at processing Data Analysis Expressions (DAX) queries more efficiently, known as “Horizontal Fusion”.
We are committed to helping our Azure Analysis Services customers unlock the enormous capabilities of Power BI as a superset of Azure Analysis Services through a smooth migration path to Power BI. As part of this effort, we are happy to announce today that Power BI has reached yet another compatibility milestone with the introduction of explicit Dataset Write permissions.
Power BI APIs can support you at any scale, but there is no one-size-fits-all API. The ExecuteQueries API is a great choice at small scale. For large-scale solutions, switch to XMLA endpoints and host your datasets on Power BI Premium.
As part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline repetitive, mundane tasks and processes. The purpose of this blog post is to help you get started running queries against datasets in Power Automate. It covers exporting data into csv files, building a solution to test datasets, and creating BI-driven cloud flows.
We are happy to announce that the ExecuteQueries REST API is now GA. By using this REST API, you can query datasets in Power BI from practically any modern environment on any platform, as long as you can authenticate with Azure Active Directory (AAD) and construct a Web request. The query functionality is comparable to XMLA read access, yet avoids dependencies on Analysis Services client libraries, requires no connection to XMLA endpoints, and works in Premium workspaces as well as in ordinary workspaces.
