How to get M query from dataflows. Power BI Server Analysis Services DMV request

olegkazanskyi — Wed, 15 Dec 2021 21:33:50 GMT

The target is to get all M codes from Power BI Service.

dataflows take a big part in the Power BI data structure.

I tried codes that work for datasets, but they apparently do not work for dataflow:

SELECT *

FROM $SYSTEM.TMSCHEMA_PARTITIONS

and

SELECT *

FROM $SYSTEM.TMSCHEMA_EXPRESSIONS

In The Power BI Workspace opened with Analysis services there is an entity named "Dataflows" with all the dataflow inside.

I try running the same codes for this entity as for datasets, but the results are weird.

Some codes show reference to a table itself, and 90% of tables are missing.

Is there a way to get M Query for all tables inside dataflow (loaded and not loaded) using DMV queries?

d_gosbell , lbendlin could you help with this issue?

Re: How to get M query from dataflows. Power BI Server Analysis Services DMV request

lbendlin — Wed, 15 Dec 2021 21:49:41 GMT

There is no XMLA endpoint access to the dataflows at the moment. You would have to export the JSON files one by one.

Or use the API