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