Forum Discussion
Helper IIIHow to manage source data used in Power BI.
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" ) )
Super UserHi 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" )
)
Helper IIII have a lot of reports so I needed a way to organize them, thank you for the information!
Hi ericjo ,
Glad to hear this was helpful. When you’re dealing with a large number of reports, keeping source data well organized really helps with accessibility and ongoing maintenance.
If you have any other questions or need more clarification, feel free to reach out.
Thank you.Hi ericjo ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.