Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Identify all Power BI reports that refer to a particular measure

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.

 

4 REPLIES 4
selimovd
Super User
Super User

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
Not applicable

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.

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
Not applicable

@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?

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors