REST API with Gateway as Web data source

[matthewmarra]

I have my data source configured in PowerBI desktop as the web option there allows to add headers and I am able to pass the tenant key in the call, however when presented with the web option in the gateway I do not have a place to pass that key in the call. I need to pass that and the authorization header.

I'd like to have live reporting online where I can share my reports but can only seem to get data refreshed in PowerBI desktop.

Thank you for any help!

[Anonymous]

@matthewmarra,

Could you please post the code in Advanced Editor of Power BI Desktop that you use to connect to your data source?

In your scenario,  if the root URL of the your api works with anonymous access, you can keep the root part of the url and add the rest to relative path in your power query code, then use Annoymous authentication in Power BI Service to refresh your dataset, there is a similar thread for your reference.

https://community.powerbi.com/t5/Service/Refreshing-a-Restful-Data-Source-with-API-Key/td-p/131298

Regards,
Lydia

[hobe1]

This may be related to a problem I have logged: http://community.powerbi.com/t5/Integrations-with-Files-and/Using-Webtrends-REST-URL-as-a-datasource...