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
bcdobbs
Community Champion
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
bcdobbsCommunity Champion
Community ChampionIf you open your XLMA end point in tabular editor you can see the struture:
and then the data source M is in the tables Partition: