Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Pull into excel/Table - all Lineage - all Reports - all Workspaces - all Connections



I need to extract from Power BI a report that shows in table format all of the following for the entire tentant:

Report Name





Any ideas?

Thank you!

New Member

Hello @v-luwang-msft ,

Thank you for the reply! I am working on getting Admin consent for the "Power BI Helper" tool recommended in your first link and will let you know if it helps when I get it working.


I dont know if the second link will help. If it does answer my question, it does so in a way I am not able to figure out 😞


More soon - thank you again!

Community Support
Community Support

Hi @RoarkeP ,

If use api, you could refer the below:

Get dataset

Get datasources


And the following article about document all Power BI workspaces, reports, datasets with no code,refer: 


similar errir refer: 



Best Regards


Hello again - I worked with a MS Support Rep and we had to abondon this effort. Apparently there is not a method for pulling the report I hoped to pull.


Thanks for your interest/efforts!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors