HOW to use REST API in Power BI Service

[pratheeban]

HI All,

I would like to know how to use REST API to retrieve the metadata of the reports, Dashboards from the Power BI Service. 

Steps I tried,

1) Created Workspace in Service

2) Created the reports in Desktop and Published it to the workspace Power BI Service

3) Created the dashboard from the Report

4) I have tried some sample REST calls to get the metadata of the reports and dashboard that are published there as per below link.

    https://msdn.microsoft.com/en-us/library/mt147898.aspx

    Example: https://api.powerbi.com/v1.0/myorg/reports (Tried using the browser)

 It is showing 404 FORBIDDEN message.

Not Sure what I'm missing here.... May I know how to learn about the REST calls in Power BI.

Thanks in Advance for your help!!!

[pratheeban]

HI All,

I would like to know how to use REST API to retrieve the metadata of the reports, Dashboards from the Power BI Service.

Steps I tried,

1) Created Workspace in Service

2) Created the reports in Desktop and Published it to the workspace Power BI Service

3) Created the dashboard from the Report

4) I have tried some sample REST calls to get the metadata of the reports and dashboard that are published there as per below link.

https://msdn.microsoft.com/en-us/library/mt147898.aspx

Example: https://api.powerbi.com/v1.0/myorg/reports (Tried using the chrome & mozilla browser)

It is showing 404 FORBIDDEN message.

Thanks in advance for your help!!

[Anonymous]

Hi @pratheeban,

I check on REST API document but not found similar api which you mentioned, I think you're testing with wrong api url.

For REST API Report operations, you need to define the 'group id' in api.

Sample:

Get Report
https://api.powerbi.com/v1.0/myorg/groups/{group_id}/reports/{report_id}
Get Reports
https://api.powerbi.com/v1.0/myorg/groups/{group_id}/reports

Regards,

Xiaoxin Sheng

[pratheeban]

Hi,

Thanks for your reply!

What I'm trying to achieve is retrieving the detailed metadata of the reports and dashboard which is published in the workspace.

How to get the dashboard and report metadata(In JSON/XML) using REST API / Is there any other way to get it? The metadata retrieved is high level whereas I needed detailed one(column used in the visualization and dataset details) etc.

https://api.powerbi.com/v1.0/myorg/groups/XXXXXX/reports

{
"id": "cXXX",
"modelId": 0,
"name": "Second Report",
"webUrl": "https://app.powerbi.com/groups/XXX/reports/xxxx",
"embedUrl": "https://app.powerbi.com/reportEmbed?reportId=xxxxx&groupId=XXXXXX",
"isOwnedByMe": true,
"isOriginalPbixReport": false,
"datasetId": "XXXXX"
}

Any help is much appreciated! Thanks

[Anonymous]

Hi @pratheeban,

How about use power bi to invoke rest api and analyze these result data? Power query contains function to expand, merge and drill to detail metadata.

Using a REST API as a data source

Regards,

Xiaoxin Sheng

[pratheeban]

Hi,

Thanks for the Response.

I think you misunderstood my question. I was asking how to retrieve the metadata of the Power BI Reports in Power BI Service.

To find the below details,

What columns used in the reports?

What dashboards in my workspace?

Where the column sourced from?

DB Details etc.