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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NakkaHemanth
Frequent Visitor

user wise underlying data for reports, dashboards, workspaces , apps in power bi service.

Hi There, 

I have a requirement, 

I want to get user-wise underlying workspaces, underlying reports, underlying dashboards, and underlying apps across Tanant in a table.

NakkaHemanth_0-1685967896861.png

Is it possible to get this kind of information in Power BI?
please help. 

I really appreciate any help you can provide.

5 REPLIES 5
lbendlin
Super User
Super User

there is no relationship between users and the other items. 

 

What are you trying to achieve with the collected data?

Hello Ibendlin, 

Thanks for your reply.

As an Admin, we wanted to know User wise how many reports & dashboards are there on what workspaces.  We wanted to fetch this data across the Tenant for querying & developing reports to get to know user-level access.

I found some Power BI Rest APIs to fetch the data, But no API is giving user-level data. 

Is there any way to get the data??

You need to distinguish between a variety of scenarios

- users that are members of workspaces

- users that have access to apps

- users that have access to workspace reports and datasets

- users that have build access/XMLA endpoint access

- users that own dataset or dataflows

- users that create or update content

- users that consume content

 

Etc etc . There are many more scenarios that all need to be covered separately.

Thanks for your information Ibendlin
Are there any direct APIs/options to
--Retrieving list of users for all reports
-- Retrieving list of users for all workspaces etc. etc.

 

Thanks in advance.

yes, there are separate API calls for each of these scenarios.  Use the tenant audit log calls and the scanner API to collect these.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.