cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omero
Regular Visitor

How to see the affected Power BI reports when I change a formula in Azure Analysis Services

Hi all,

We will modify the formula of an object(for ex. measure) in Azure Analysis Services.
but we do not know where this measure is used.
When we select a measure in Aure Analysis Services, how can we see the affected Power BI reports?

Thanks

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@omero 


There is no build in feature to do that. Normally you can use  VertiPaq Analyzer to track the dependencies in DAX. It extracts all the DAX expressions for calculated columns, measures and calculated tables.

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@omero 


There is no build in feature to do that. Normally you can use  VertiPaq Analyzer to track the dependencies in DAX. It extracts all the DAX expressions for calculated columns, measures and calculated tables.

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.