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

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.