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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DAXUser
Frequent Visitor

Power BI File Report Object Details

We looking for Metadata Report Object detail of the power report. Basically we looking for Page name, Visual name, Measure name and Table name of the dashboard/Report. 

 

 

1 ACCEPTED SOLUTION
v-kongfanf-msft
Community Support
Community Support

Hi @DAXUser ,

 

Based on your description, the best way to get the meta information for a report is in the form of a reset api:

Permissions
The user must have all of the following, unless a requirement doesn't apply:

Write permission on the specified report.
Build permission on the target dataset, required if the targetModelId parameter is used.

Try like below:

GET https://api.powerbi.com/v1.0/myorg/reports

 

vkongfanfmsft_0-1706867139975.pngvkongfanfmsft_1-1706867197061.png

 

Also, you can try powershell to get more info.

Get-PowerBIDashboard (MicrosoftPowerBIMgmt.Reports) | Microsoft Learn

Get-PowerBIReport (MicrosoftPowerBIMgmt.Reports) | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

3 REPLIES 3
DAXUser
Frequent Visitor

Hi @Kishore_KVN 

   

    I got the expected output. I refered this link - https://www.elegantbi.com/post/exportreportobjects 

for my requirement.

   

 

 

v-kongfanf-msft
Community Support
Community Support

Hi @DAXUser ,

 

Based on your description, the best way to get the meta information for a report is in the form of a reset api:

Permissions
The user must have all of the following, unless a requirement doesn't apply:

Write permission on the specified report.
Build permission on the target dataset, required if the targetModelId parameter is used.

Try like below:

GET https://api.powerbi.com/v1.0/myorg/reports

 

vkongfanfmsft_0-1706867139975.pngvkongfanfmsft_1-1706867197061.png

 

Also, you can try powershell to get more info.

Get-PowerBIDashboard (MicrosoftPowerBIMgmt.Reports) | Microsoft Learn

Get-PowerBIReport (MicrosoftPowerBIMgmt.Reports) | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Kishore_KVN
Super User
Super User

Hello @DAXUser what is the role you have for that workspace. If you can download te file service environment then try to do that atleast you should have edit access for the report to look at it in service environment itself. But unless you have pbix file, you can't see the measures. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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