David Schneider on 05 Apr 2016 23:50:29
Currently only GET requests are supported as data source. A 3rd party systems use POST request to provide data.
- Comments (4)
RE: Support POST requests
A MSFT Support case has just concluded after many weeks of effort and testing with the result, it can't be done. The MSFT Support Engineers for PowerBI tried very hard to make this work but it's simply not possible. It's very unfortunate that the POST method using basic authentication is not supported. As you consider whether to expend engineering resources to address this issue, please review the following Microsoft Support Case: TrackingID #2303140040007067 (worked by: hardiksoni and talakaraki). Our company offers a Cloud Native SaaS platform for data analytics but many of our customers use PowerBI and want to access their data from our platform using PowerBI...however, our API's require POST method and basic auth. So now their investment in PowerBI doesn't help them and they are limited to accessing their agency's data from our client. And while we provide API access, to give them choice, it does them no good if they are using PowerBI.Thank you for your consideration.
RE: Support POST requests
...but not only anonymous POST-requests. We need Windows Authentication / NTLM.
RE: Support POST requests
This is also needed for connecting to graph databases like Noe4j. Noe4j only accepts http post requests and it's not a trivial task for folks to write, edit, and debug an advanced Power Query script to make the post request.
Since there is currently no support for R or Python packages for Neo4j either, the only method for accessing a Neo4j database in Power BI is through the http post API, if you want to have Power BI Online Service refresh data from Neo4j.
Same for using the On-Premises Data Gateway going against custom web api apps. Several of my clients exclusively use http post api's to access on-prem systems data, and it's just tough to build that for most folks in Power Query.
Come to think of it, the same goes with the Bing Maps service - that's also an http post rest api call too. So many examples.
RE: Support POST requests
POST API needs to implemented in Power Bi. As most of the governament systems (I am part of using it) are old and use XML and SQL connection. I performed XML POST API request from server and could update through Power Bi Desktop version, but as soon as i published it and put auto update, it refused. I and others like me feel this problem needs to be addressed.