Identify all Power BI reports that refer to a particular measure

[Anonymous]

I am using Power BI Desktop for Reporting Services. The reports are deployed to a Power BI Report Server. The reports all use a SSAS tabular model. There are about 50 reports.

I have updated the logic for a measure in the tabular model. Now I need to test every report that uses that measure, either on a visual or by referring to it in a report-level measure.

How can I identify only those reports that use that measure so that I can test only those ones and not all 50 reports?

In the SSRS days this could be accomplished by searching the ReportServer database in the Catalog.Content column.

[selimovd]

Hey @Anonymous ,

you can either create a usage report on the report server. There you can then filter for data source and you will get the reports that are using the SSAS.

As an alternative you could also try to use the usage statistics from he SSAS server to get more insights. But this I personally haven't done. Check the following article on how to do that:

https://adatis.co.uk/generating-usage-statistics-from-a-ssas-tabular-cube/

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[Anonymous]

You have suggested creating a usage report on the report server. Could you please explain in more detail how I can do this to identify which Power BI reports are using a particular measure? 

The link you provided for "Generating Usage Statistics from a SSAS Tabular Cube" has a sectpion for Power BI reports. Unfortunately that is limited to only reporting report users and report duration - there is no ability to examine a report to find out if it uses a particular measure.

Could I ask you to please delete your post? It does not answer my question and pollutes the thread for others.

[selimovd]

Hey @Anonymous,

you can get the whole usage data from the views ExecutionLog and ExecutionLog3. They summarize everything what is going on, on your report server. But as far as I remeber it keeps data only for something like 60 days.

You can build a report based on these two views.

Nikola Ilic wrote a great article on how to do that:

https://towardsdatascience.com/check-power-bi-usage-metrics-on-report-server-ffb5ea6056db

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd, neither ExecutionLog nor ExecutionLog3 provide any information about which measures are used in which Power BI reports. Can you explain how to use these objects to answer my original question, please?