Forum Discussion

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_P...

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
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
  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 .
  - 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 .
    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 .

Related content