As of yet, Power BI can not query an API that uses authentication via a token added to the HTTP header. While this works when used in Power BI Desktop, the query crashes after uploading to powerbi.com.
9 Comments
- we have similar requirement. Following are the details. Details: Data base and web server has hosted outside Azure. Have Client_ID and Client_Secret details. Resource URL https://app1pub.xxx.net/dev/v1/servicelocation Method GET HTTP Header Authorization: Bearer [ACCESS_TOKEN] Note: [ACCESS_TOKEN] being the access token received during one of the authentication calls Result [ {"serviceLocationId": 1, name: "Home"}, {"serviceLocationId": 2, name: "Beach resort"}]
- We also have similar requirements. This works in Desktop but fails after publishing. Error response as follows: Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details Activity ID: b0a09f25-d32b-4160-a504-8493c112f67c Request ID: f7a8849d-ae32-3818-fb90-832d9f58d3f9 Status code: 400 Time: Thu Jul 14 2016 00:43:58 GMT-0700 (Pacific Daylight Time) Version: 13.0.1500.395 Cluster URI: https://wabi-west-us-redirect.analysis.windows.net Details: The credentials provided for the Web source are invalid. (Source at https://www13.v1host.com/GettyImagesEnterprise/rest-1.v1/Hist/Story.)
- PowerBI team, Has this issue been fixed with the latest version of PowerBI? Waiting for your response. Thanks
- 'I'm having the same troubles. It works in power bi desktop, but I cannot set up auto refresh in power bi service. Data are extracted as follows: = Web.Contents("https://app.idoklad.cz/developer/api/IssuedInvoices?PageSize=1000000&Page=1",[Headers=[#"SecureToken" = "
",#"X-App" = "iSmart",#"X-App-Version" = "1.0"]]) - yes please... this is a big issue for us...
- yes please
- ZappySys has released Drivers for REST API (JSON / XML / SOAP). Using these drivers you can connect to virtually any API service in Power BI. It comes with many advanced options such as OAuth Token, Pagination, Error Handling , Query Editor and many more. See below links. https://zappysys.com/blog/howto-import-json-rest-api-power-bi/ https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/ Hope this helps!
At present it is quite difficult to implement any token-based authentication scheme from Power Query. It often requires a POST with credentials potentially visible in code. It is also quite labour-intensive.
If possible this should be generalised to cover not only the Web.Contents library function but also alternative connectors e.g. FHIR.Contents.
- Status added:Needs Votes
