Using the Power BI Rest API

[ghdunn]

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!

[v-cazheng-msft · Accepted solution]

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.

[ghdunn]

@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 🙂

[v-cazheng-msft]

Sure. Hope your problem can be solved.

Best Regards

Caiyun Zheng

[amitchandak]

@ghdunn , Not very sure, but check if this can help

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal

[ghdunn]

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?