Ben on 25 Jan 2016 21:29:37
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.
- Comments (8)
RE: Get data from API with authentication token
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.
RE: Get data from API with authentication token
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!
RE: Get data from API with authentication token
yes please
RE: Get data from API with authentication token
yes please... this is a big issue for us...
RE: Get data from API with authentication token
'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"]])
RE: Get data from API with authentication token
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.)
RE: Get data from API with authentication token
PowerBI team,
Has this issue been fixed with the latest version of PowerBI?
Waiting for your response.
Thanks
RE: Get data from API with authentication token
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"}]