Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Add support for supplying refresh token for OAuth source in Gateways - Update Datasource API

We are connecting to our data source using OAuth credentials. Sometimes, Power BI requires us to re-enter our credentials in the Service, when the token has been invalidated for some reason (e.g. change of dataset ownership). We then update the OAuth credentials via the "Gateways - Update Datasource" API. We provide a valid Bearer Token as per the OAuth update example and everything initially works as expected. However, obviously the bearer token expires after an hour (the default for most bearer tokens), and the Power BI Service asks us to re-enter our credentials. We then have to run this code every hour (or at least before any refresh) to make sure the credentials don't expire. This doesn't happen if you update the credentials through the UI - refreshing of the token must be being handled by the Power BI Service behind the scenes. But there is no option to provide a "refresh token" in the above "Update Datasource" API. Please add support for supplying a refresh token when updating datasource credentials programmatically for an OAuth-authenticated data source.
Status: New
Comments
piotr_gajdecki
New Member

This is a must!

fabio_righini
New Member

our customer has a scenario that requires refresh token.

but i think this should be a fundamental feature of the api, or not?

sandesh_poudel
New Member

We need this feature as well. It is blocking our scenario where the service account needs to take ownership of 100s of powerbi reports.

sbind
New Member

Can someone please guide me how you get bearer token to pass to "Gateways - Update Datasource" API?

tschubiger
New Member

Oh wow, it has been 3 years already. This is a crucial feature and the fact that it works over via the PBI interface shows that it is not a security issue. Would be great if someone from the product team could comment on this.

yassine_trad1
New Member

It's 2025... Come on guys... Why does the PBI product team hate automation ? Making every devops guy's life so miserable.. Please make the REST API match the UI/browser functionality on the important stuff...

fbcideas_migusr
New Member
Status changed to: New