Backing Up Semantic Models
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.
Getting ready
To prepare for this recipe, follow these steps:
- Ensure...
