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