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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors