Forum Discussion

nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
8 months ago
Solved

Power BI GET API with JSON body – how to handle?

Hi all,

I’m trying to call a REST API in Power BI that requires parameters like FromDate and ByDate in the JSON body, even for a GET request.

Problem: Power BI does not support GET requests with a body, so calls fail with 400 Bad Request or ask for credentials.

Has anyone solved this?

Workarounds, custom connectors, or it would be the best to ask API developer to "move" parameters from body to url parameters?

In Postman everything works fine, it seems like a limitation of Power BI, but can't find any documentation.

Thanks!

Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    8 months ago

    nandic This would require you to create a custom Power Query connector for that API. If you could get the developer to move the parameters to the query string of the URL that would allow you to get around that requirement.

2 Replies

  • GeraldGEmerick's avatar
    GeraldGEmerick
    Icon for Memorable Member rankMemorable Member
    8 months ago

    nandic This would require you to create a custom Power Query connector for that API. If you could get the developer to move the parameters to the query string of the URL that would allow you to get around that requirement.