Source information with DMV or INFO.DAX function

[Lorili]

I am using a dataflow Gen2 to write back metadata about my PowerBI dataset. To make a complete view of my data lineage I would like to extract the sources of my partitions. I have used the TMSCHEMA_Partitions DMV function to retrieve this information (the same result can be achieve by using the INFO.Partitions DAX function). 

For tables/partitions that I did not alter in PowerQuery I can find the source table, but for others only the last step of the PowerQuery definition is shown. See below

Does anyone know a method on how to retrieve the source information of my partitions/tables in my PowerBI dataset? Thank you!

 

[Lorili]

Great, it would be even better if I could get the source fields for every column of my dataset

[Anonymous]

Hi @Lorili ,

We have a response from internal team - 
" The ‘QueryDefinition’ shows you the M query and the source behind the partitions created using Power Query. For non-power query sources you can match the DataSourceID in INFO.PARTITIONS() with the ID from INFO.DATASOURCES(). "

Hope this is helpful. Please let me know incase of further queries.

[Anonymous]

Hello @Lorili ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[Anonymous]

Hello @Lorili ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

[Lorili]

Hi!

Thank you for your reply. Unfortunately, this is not completely the solution I am looking for, as I will not be able to build a data lineage back to my Azure SQL DB. Any suggestions on this?

[Anonymous]

Hi @Lorili ,

Before I reach to internal team, can you please share your ask again.
So, I will try my best to get some information from team.

Thank you

[Anonymous]

Hello @Lorili ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.