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