cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to refresh REST API with POST?

Dear All,

 

We are trying to build reports for Aurea CRM. This is an on-prem CRM, that provides webservices to access the data. These are REST API-s, but unfortunatelly they are using POST method to get the data. I've succesfully created a report for that webservoci in PowerBI desktop, and also i can refresh locally, but after i've published, i cannot add it to the Gateway as a Web "resource". I think the issue is, because the powerbi service tries to get that web resource via GET method, but i cannot see any settings where i could tell that it will be a POST. Could you help me out with these? Any idea would be welcome! See the linked screenshots:

https://photos.app.goo.gl/6VZg6M5Mbh7ZQp9bA

 

Thx,

Gábor

 

 

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: How to refresh REST API with POST?

Power BI will do a POST if you pass provide Content to the Web.Content call

When you select, "Show details" when adding to the gateway, what does it show?

Also, if you are only using web service calls, you shouldn't have to set up the gateway

 

It would be nice to see your M code for the query, it may help in troubleshooting

Highlighted
Regular Visitor

Re: How to refresh REST API with POST?

HI,

 

thx 4 the reply. Yep I do send the Content. And it makes a POST call from Desktop, that's fine. The problem is, that I cannot set the Web source in PowerBI service as a POST call. It always send the request against the Web source as a GET request and this results a 404 error, so i was not able to configure the gateway.

I used the gateway to the webservice, because i was not sure, whether our company policy allows to publish that webservice to the internet (which was available only in the intranet before).

After several discussion the webserivice was made available to the internet as well and i could get rid of the gateway.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors