Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 dataset M Queries
select * from
$system.discover_m_expressions
But when I run it for a dataset built completely from dataflows, it doesn't show anything!
Is it a bug?
Solved! Go to Solution.
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
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
It works!
Thank you!
No 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
You literally changed my life today!
I wondered where all these requests come from, now I know!
I will dig deeper!
Big kudos!