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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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