Showing results for 
Search instead for 
Did you mean: 
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


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors