Posts tagged #XMLA

Extracting SQL Database/Table Names From Your Power BI Dataset!

Video by: Reid Havens

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT 🔗

Extracting All M-Code from a Power BI Dataset

(Livestream Replay) Explaining the XMLA Endpoint and its Use Cases

Power BI is merging with Azure Analysis Services! Microsoft is now opening up and giving us full access to the powerful Analysis Services engine in the Power BI service. This gives us semantic models that serve as the single source of truth for the whole enterprise. Manage the models (datasets) with the tools you know and love and give read and write-access to a variety of Microsoft and third-party client tools.

GUEST BIO 📄

Just Blindbaek is an independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk).

RELATED CONTENT 📄

Just's Twitter
Just's Website
XMLA Blog Post