Forum Discussion
ericjo
Helper III
Helper IIIHow to manage source data used in Power BI.
Hello, I'm in charge of Power BI development and operations. I've recently become very interested in operations, and as the number of Power BI reports I'm developing increases, I'm curious how you m...
Hi ericjo
In Power BI Desktop and without an API, you can use the DAX Query view and execute INFO.PARTITIONS and then filter [QueryDefinition] column to something that contains let and source which is normally what Power Query tables start with.
EVALUATE FILTER ( INFO.PARTITIONS (), CONTAINSSTRING ( [QueryDefinition], "let" ) && CONTAINSSTRING ( [QueryDefinition], "source" ) )
rajendraongole1
Super User
Super Userericjo - Reports should never depend directly on raw or unstable data sources.
They should depend on controlled, observable semantic models.
ericjoHelper III
Helper IIII agree. I wanted to organize the sources used by each report to enable a quick response to similar issues in the future.