cancel
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.

Reply
RoarkeP
New Member

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

Hello-

 

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

Report Name

Workspace

Datasets

Connections

 

Any ideas?

Thank you!

3 REPLIES 3
RoarkeP
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!

v-luwang-msft
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:

https://radacad.com/document-the-power-bi-tenant-objects-workspace-reports-datasets-dataflows-with-n... 

 

similar errir refer:

https://community.powerbi.com/t5/Desktop/API-to-get-the-list-of-reports-and-dashboards-created-in/m-... 

 

 

Best Regards

Lucien

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

Announcements
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