Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.