Forum Discussion
Updating credentials for a cloud data source as a service principal
I'm trying to update credentials for a cloud data source that uses OAuth2 as a service principal. The purpose is to be able to refresh the dataset. We would prefer not to use an on-premises gateway f...
This works fine for datasources that are part of a gateway, but it does not work for cloud (non-gateway) datasources.
I can't believe I am saying this but you can add cloud data sources to your gateway. ( I strongly dislike that, but it might help in your case)
So ideally, we'd prefer not to have to maintain on-premises gateways. However, if that's the only workaround, we might end up having to do it.
The other possibility I'm considering is to use a master user instead of a service principal because we can manually set credentials on app.powerbi.com for it, and the credentials can last for a long time. This has other drawbacks though.