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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
SvanEs
Frequent Visitor

How to create an overall Power BI report on published reports in all workspaces

Hi, 

 

I hope someone in the community can help me out on this one 🙂

 

In our organization a lot of reports are published to a lot of workspaces. Users are getting access to different reports and datasets with different permissions. From a GDPR perspective I would like to create an overall Power BI report on all reports in all the workspaces, including who has access, which permissions they have, in which workspace the report resides, and if possible also some reportspecific data from used tables, user metrics, etc. 
I've been searching the community for answers and can't seem to find the answer, although I do see references to using a rest api. Is there a way to create a report whithout having to use an rest api? 
(I do have access to the admin portal but that doesn't give me the insights either)

 

Thanks in advance!

1 ACCEPTED SOLUTION

3 REPLIES 3
lbendlin
Super User
Super User

Talk to your O365 tenant admin and ask them for the relevant audit logs.

Hi, 

Thanks for your response. 

I do have access to the admin portal, but when going to the audit logs everything is greyed out. 
So, only the tenant admin has access to the logs?

SvanEs_0-1639648252856.png

 

Yes

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.