PBI Service: refresh of API dataset with bearer token authorization and changing date parameters

[pooling]

Hi guys, please help !

In PBI Desktop I load my client's json data via API (GET method) with authorization header (bearer token), but I fail to do it in PBI Service (in order to have automatic data refresh) because there is no place to insert my bearer token.

In PBI Desktop I created a list of queries, most of them have similar structure:

But one query has 2 parameters (start date and end date) which change daily:

When I publish my dataset to PBI Service, it says that I don't need to set a gateway connection as all of the data is in the cloud, but there is no place to insert my bearer token and eventually the dataset can't be updated from the PBI Service.

Guys, I know that you know everything, please help - how should I proceed?

I have installed on-premises data gateway on my computer, but I do not understand how I should fix this and where I should insert bearer token and these changing date parameters.

[rodrigo_avf]

I'm having the same difficulty, has anyone found a solution for this?

[ranbeermakin]

@pooling don't hard code the bearer token... in such cases I usually create a custom connector. It gives you flexibility to authenticate with your own Oauth flow.