Forum Discussion

Lorili's avatar
Lorili
Frequent Visitor
2 years ago

Source information with DMV or INFO.DAX function

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!

 

 

Need Help
Pipelines

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • Lorili's avatar
    Lorili
    Frequent Visitor
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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 .