sas
2 Topics
How to get M query from dataflows. Power BI Server Analysis Services DMV request
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?Solved2.4KViews0likes1CommentDMV request to Power BI Server Analysis Services for hidden tables in PowerQuery
I try to get the list of tables with M codes from PowerBI online Analysis Service. I managed to get the required data with the request: SELECT * FROM $SYSTEM.TMSCHEMA_PARTITIONS But it doesn't show any tables that were selected not to "Load" in PowerQuery. The purpose of this task is to get all data connections from a dataset and hidden tables are essential. Does anyone know how to get the hidden tables' codes?Solved5.6KViews0likes8Comments