Richard Tkachuk’s BI Blog
Power BI, Analysis Services, and DAX
Latest from the Blog
In Power BI Premium, the XMLA endpoint enables many operations previously unavailable – one being the ability to cancel a dataset refresh. To do so, you’ll need to be a workspace admin and launch a few commands from SQL Server Management Studio (SSMS). First, use SSMS to connect to the XMLA endpoint (you can learnContinue reading “How to Cancel a Power BI Refresh”
XML for Analysis was defined back in 2001 as a standard way to access and manage analytic systems. A good metaphor for XMLA is its cousin SQL – SQL is a standard approach in relational systems for both querying and defining relational objects. Like SQL, XMLA is that but for analytical systems. (Well, almost. More aboutContinue reading “What is XMLA and why should you care?”
Power BI Premium support for the XML for Analysis (or XMLA) protocol is in public preview. XMLA is an industry standard for data access for analytic client and management applications (and has been an open standard for almost 20 years). Azure Analysis Services and SQL Server Analysis Services both use the XMLA protocol for communicationsContinue reading “Migrating from Azure Analysis Services to Power BI Premium”
Get new content delivered directly to your inbox.