Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Get data from API with authentication token

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.
Status: Needs Votes
Comments
NAVEED
New Member
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
New Member
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
New Member
PowerBI team, Has this issue been fixed with the latest version of PowerBI? Waiting for your response. Thanks
fbcideas_migusr
New Member
'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
New Member
yes please... this is a big issue for us...
pbiideas1
New Member
yes please
npatel10
New Member
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
New Member

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.

fbcideas_migusr
New Member
Status changed to: Needs Votes