Get data from API with authentication token

[benjamin_konra1]

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.

[NAVEED]

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"}]

[mike_weimer]

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.)

[JAYPAT]

PowerBI team, Has this issue been fixed with the latest version of PowerBI? Waiting for your response. Thanks

[fbcideas_migusr]

'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"]])

[israel_cayco]

yes please... this is a big issue for us...

[pbiideas1]

yes please

[npatel10]

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!

[james14]

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.