topic Re: Issue with REST api for GET report data in Developer

Issue with REST api for GET report data

ekumar-0522 — Wed, 09 May 2018 07:53:43 GMT

Im trying to get individual report data by using this rest api

https://api.powerbi.com/v1.0/myorg/reports/{report_id}

and even i tried with

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

what is group id?

in the place of group id i mentioned the id which u can see in screenshot

after mentioning this report id and group id in rest api im getting this which u san see in screenshot

may i know what is the issue

can you help me out with this how can i resolve this issue?

Thanks

sai kumar

Re: Issue with REST api for GET report data

Anonymous — Wed, 09 May 2018 11:58:50 GMT

Hi @ekumar-0522,

Group is the name used in the REST API for the (App) Workspace in the PowerBI service.

How did you get the token used in the api call (Bearer ...)? It seems that it doesn't allowed to access the report.

Regards,

Thanos

Re: Issue with REST api for GET report data

ekumar-0522 — Wed, 09 May 2018 18:43:42 GMT

Hi @Anonymous

The token which i have used that i got from this ret api

https://login.microsoftonline.com/<tenant id>/oauth2/token?grant_type=password

so, how can i get the data of individual report?

what headers and authorization should i need to pass for it?

can you help me with this issue.

Thanks

sai kumar

Re: Issue with REST api for GET report data

Anonymous — Wed, 09 May 2018 19:40:36 GMT

Hi @ekumar-0522
Please refer to the above links to learn more on how to get an access token for PowerBI REST API.

https://docs.microsoft.com/en-us/power-bi/developer/get-azuread-access-token
https://community.powerbi.com/t5/Developer/Power-BI-REST-API-using-postman-generate-embed-token/m-p/310054

Hope it helps.

Thanos

Re: Issue with REST api for GET report data

ekumar-0522 — Thu, 10 May 2018 11:41:46 GMT

Hi @Anonymous

Im trying to get the individual report data as you can see my group name is"Test Workspace"

and the metadata as you can see "isReadOnly": false

is that the issue?

when I mentioned same group id and report id which I want to fetch

but the thing is I'm getting an 401 unauthorized error as you can see the screenshot above

can you help me with this

Thanks

sai kumar

Re: Issue with REST api for GET report data

v-micsh-msft — Thu, 10 May 2018 15:14:52 GMT

and the metadata as you can see "isReadOnly": false

is that the issue?

No, this is not the issue.

Please check the group membership, switch to Group Owner and then try it again.

The Header is OK, for the Body part within postman, input the following within Raw format:

{
  "accessLevel": "View",
  "allowSaveAs": "false"
}

Regards,

Michael