Power BI usage view report in Power BI desktop!

Hello everyone,

I hope someone will be able to answer this question. I want to create a Power BI usage report in Power BI desktop. I can create usage report in individual workspaces, but I am unable to create a report across all workspaces.

Is there a quick way to create Power BI usage report across all workspaces?

Kind Regards,
Naila

1 Like

As far as I’m aware, you can only create a Power BI Usage report inside the individual workspaces.

Happy to be proved wrong.

Saying that…

Power BI Usage Metrics Across All Workspaces: Step by Step (proserveit.com)

1 Like

the keyword here is ‘quick’ - and I think the answer is that no, there is not a fast way to do this. You also need to have some additional access that not all PowerBI users will have.

I see that @DavieJoe has already found my first link I was going to provide, which requires you to have (in addition to your PowerBI Pro license):

  • Azure AD Global Admin account
  • Azure AD Application
  • Power BI Streaming Dataset

Or, there is this option from Radacad which requires that you have access to the PowerBI Administrator account, and the O365 audit log:

2 Likes

Hi @Naila , did the response provided by the users above help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

Hi @Heather @DavieJoe

Thank you so much for your responses. You are right that I will have to get additional access to get it done. After reading the blogs, I have reached to following conclusion to implement it:

  1. Since I might not be able to get Azure Global admin account. I will ask IT team to provide Power BI audit file in One drive. They can create a scheduled process to update that file daily.
  2. I create a report based on that file.

I think this is might be the option that my organization will prefer. Thanks again for your time and valuable suggestions.

Kind Regards,
Naila

2 Likes

sounds like you have a workable plan - I’d be interested in seeing what your customized report ends up looking like :slight_smile:

I have customized my usage reports - but only for individual workspaces, not for all workspaces.

1 Like

Hi @Naila

Before start using the Power BI Audit log, make sure you have a inventory of all your assets on power bi services (Workspace, datasets, reports, users, app, etc).

There are difference method that you can use, the following video is one of them:

Is a series of 4 videos.

1 Like