topic Get Reports REST api not working - Showing 400 Bad Request in Developer

Get Reports REST api not working - Showing 400 Bad Request

pratheeban — Fri, 29 Jun 2018 04:03:07 GMT

Hi All,

I am trying to retrieve the report metadata using the REST API provided,

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreportingroup

REST call tried: https://api.powerbi.com/v1.0/myorg/groups/f702bdb7-e372-4990-a828-5e5449c6f676/reports/7d36d8aa-4ae8...

I did register the application and got the token. All the other REST calls are working Except this... (Showing 400 Bad request).

Not sure what I'm missing here. Pls let me know

Thanks

Re: Get Reports REST api not working - Showing 400 Bad Request

v-jiascu-msft — Mon, 02 Jul 2018 06:43:39 GMT

Hi @pratheeban,

Seems something is wrong. I have reported this issue to the Product Team: CRI 75423606. I will update here.

Best Regards,

Dale

Re: Get Reports REST api not working - Showing 400 Bad Request

v-jiascu-msft — Thu, 05 Jul 2018 02:45:27 GMT

Hi @pratheeban,

Did you use " 'Accept' HTTP header" in the request? Maybe you can try to remove it.

Best Regards,

Dale

Re: Get Reports REST api not working - Showing 400 Bad Request

luismangahr — Fri, 06 Jul 2018 11:08:48 GMT

Hi @v-jiascu-msft

I have the same and I have no Accept header. See cURL command obtained from the postman I am using (I have modified it by manually adding "......." to remove id's):

curl -X GET \
  https://api.powerbi.com/v1.0/myorg/groups/b931........../reports/7bbf.......... \
  -H 'Authorization: Bearer eyJ0e..........' \
  -H 'Cache-Control: no-cache'

Re: Get Reports REST api not working - Showing 400 Bad Request

v-jiascu-msft — Wed, 11 Jul 2018 12:51:21 GMT

Hi @luismangahr, @pratheeban,

I tested the workaround. Please set the header "Accept" to "None" explicitly. It's None in Python. Please try it and give some feedback.

headers = {"Authorization": token, "Accept": None}
r = requests.get(get_url, headers = headers)

Best Regards,
Dale

Re: Get Reports REST api not working - Showing 400 Bad Request

luismangahr — Wed, 11 Jul 2018 14:08:50 GMT

Thanks, @v-jiascu-msft, it actually worked! Then, this is a bug, right? In that case, I guess it is identified and to be solved?

Just to add, I found that you can set the "Accept" header to "None", "Noffsfne", "j" or any other invalid value. All valid values I quickly tested (e.g.: "application/json", "message/http" or "text/html") ended up in a "400 Bad Request".

But again, thank you, because this unblocks our research on the Power BI REST api.

Re: Get Reports REST api not working - Showing 400 Bad Request

v-jiascu-msft — Thu, 12 Jul 2018 00:57:42 GMT

Thanks for sharing, @luismangahr. This issue will be fixed. We can work with the workaround for now.

Best Regards,

Dale