Forum Discussion
olegkazanskyi
Helper II
Helper IIXMLA dataset tables created with dataflow do not have M code
We want to pull M code from Power BI Service to get information that we can't with using API, like a specific stored procedure used in a table, all appends and merges etc. This code shows all dat...
Hi,
That returns any shared expressions in M which I thought were things like parameters and functions.
In tabular for modern data sources like data flows the M expressions are stored in the table partition which can be accessed with:
SELECT *
FROM $SYSTEM.TMSCHEMA_PARTITIONS
olegkazanskyiHelper II
Helper IIIt works!
Thank you!
bcdobbs
Community Champion
Community ChampionNo problem, I've learnt something new there so thank you!
Following code gives you list of all those queries:
SELECT * FROM $System.DBSchema_Tables
WHERE TABLE_TYPE = 'SCHEMA'
ORDER BY TABLE_NAME ASC
which is from Dynamic Management Views (DMVs) in Analysis Services | Microsoft Docs
- olegkazanskyi
You literally changed my life today!
I wondered where all these requests come from, now I know!
I will dig deeper!
Big kudos!