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
ghdunn
Helper III
Helper III

Using the Power BI Rest API

Hi,

 

I have started experimenting with the Power BI Rest API.  I can (for example) use the 'Try It' function on this page:

 

Reports - Get Reports (Power BI Power BI REST APIs) | Microsoft Docs

 

..and bring back details of a report.

 

I have two questions:

 

1. if i wanted to make this call through Power BI itself, what would i use?  Would I use the OData feed?  Or Web?  How would i add the "Authorisation" Synax which is shown below.  Could anyone point me at a help resource for this?

 

GET https://api.powerbi.com/v1.0/myorg/reports
Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIn etc etc

2. Is there any way of getting more metadata on each individual report...for example what Visualizations a report contains, and ideally what is the metadata of the visualisation?

 

Thanks!

 

 

 

 

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

hi, @ghdunn 

For your first question, you can refer Using REST API as a data source. A link provided by the Super User may help you. For the second question, you can refer How to get pages and visuals list via REST API.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? 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

5 REPLIES 5
v-cazheng-msft
Community Support
Community Support

hi, @ghdunn 

For your first question, you can refer Using REST API as a data source. A link provided by the Super User may help you. For the second question, you can refer How to get pages and visuals list via REST API.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

@v-cazheng-msft 

Many thanks for the response...could you give me the weekend to review..i will look to close the question if i can get it working 🙂

Sure. Hope your problem can be solved.

 

Best Regards

Caiyun Zheng

amitchandak
Super User
Super User

Thanks @amitchandak but that is a very different route...I would prefer to do it simply all in Power BI...is there any simple way of passing the authentication string?

 

Also..any thoughts on the second part of my question?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors