How to find all datasets and dax measures referencing to specific visuals?

[jaryszek]

Hello,

I am looking for a way to get all referenced DAX measures and datasources per visual. 
It is possible from power bi desktop or javascript api ? Or maybe another tool?

Best Wishes,
Jacek

[V-yubandi-msft · Accepted solution]

Hi @jaryszek ,

Thank you for reaching out to the Microsoft Fabric community.

To extract all referenced DAX measures and data sources for each visual in a Power BI report, you can use the following methods.

1.  Power BI Desktop includes a built-in Performance Analyzer tool that enables you to capture the DAX queries generated by each visual. By analyzing these queries, you can determine the measures and data sources used.

2. DAX Studio is a sophisticated external tool designed for in-depth analysis and metadata extraction from Power BI models. It enables the retrieval of all measures and their definitions, providing valuable insights into the calculations utilized throughout your report.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.