Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pratheeban
Frequent Visitor

Get Reports REST api not working - Showing 400 Bad Request

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

6 REPLIES 6
v-jiascu-msft
Employee
Employee

Hi @pratheeban,

 

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

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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'

 

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)

Get Reports REST api not working - Showing 400 Bad Request.png

 

 

 

Best Regards,
Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Employee
Employee

Hi @pratheeban,

 

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

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.