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
girdharimondal
Frequent Visitor

How to get list of all artifacts under a P1, P2 node

Team.

 We want to pull all the artifacts under a P1 , P2 node to do some analysis. Is there any way to acheieve this? Please suggest.

Thanks,

Girdhari Mondal

3 REPLIES 3
girdharimondal
Frequent Visitor

Thanks for your response. Would you able to help  with a sample power shell script as well which can be refer? 

I suggest you start with this blog. Creating scripts for Power Shell isn't really a Power BI skillset, but an admin skillset. A good admin can run powershell scripts on any part of the organization, not just Power BI.

 

Working with PowerShell in Power BI | Microsoft Power BI Blog | Microsoft Power BI



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
edhans
Super User
Super User

There is not one command to do this, but the Power BI REST API can handle this. For example - Admin - Dataflows GetDataflowsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn will get a list of all dataflows in the org. There are capacity commands, datasets, workspaces, etc. You'd just need to spend a bit of time in PowerShell writing a script to crawl through the workspaces you want (assigned to those capacities) and export the data in JSON format. From there, just use Power Query to extract that data and write a report in Power BI.

There is also, of course, the Power BI metrics app you have access to, but it is somewhat limited in what it provides, mostly performance related. Super useful, but won't answer your specific question.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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.

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