cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pooling
Regular Visitor

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

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:

 

Screenshot 2021-05-14 at 17.32.56.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

Screenshot 2021-05-14 at 17.34.56.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

Screenshot 2021-05-14 at 17.47.31.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

1 REPLY 1
ranbeermakin
Resolver III
Resolver III

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!