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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors