Forum Discussion
Helper IIXMLA dataset tables created with dataflow do not have M code
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
Community ChampionHi,
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
Helper IIIt works!
Thank you!
- bcdobbs
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 ASCwhich 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!