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

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

Anonymous — Wed, 07 Apr 2021 19:28:36 GMT

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

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

Anonymous — Mon, 12 Apr 2021 01:33:47 GMT

Anonymous

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.