Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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.
Is it possible to get this kind of information in Power BI?
please help.
I really appreciate any help you can provide.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
32 | |
32 | |
25 | |
23 |
User | Count |
---|---|
35 | |
33 | |
21 | |
21 | |
15 |