-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Microsoft Power BI Cookbook
By :

Power BI Premium capacities, as well as Power BI Premium Per User (PPU) and Power BI Embedded workspaces, are capable of exposing an XML for Analysis (XMLA) endpoint. XMLA is the communications protocol used by Analysis Services and thus the XMLA endpoint allows workspaces within the Power BI service to act as Analysis Services servers. This means that client tools such as Power BI Desktop, Excel, Power BI Report Builder, SQL Server Management Studio (SSMS), SQL Server Profiler, Visual Studio, PowerShell, and other third-party client tools such as Tabular Editor, ALM Toolkit, and DAX Studio can leverage the XMLA endpoint to operate against XMLA-enabled workspaces as if they were Analysis Services servers.
This recipe provides examples of leveraging the XMLA endpoint to perform operations that are otherwise impossible, or much more difficult, to achieve otherwise.
To prepare for this recipe, follow these steps: