Forum Discussion

JAnder's avatar
JAnder
Icon for Helper II rankHelper II
4 years ago
Solved

Update Datasource and Refresh using Service Principal

I am working in a multi-tenancy setup where each tenant has their own database. I am uploading a pbix file to a workspace and then trying to update the datasource to the correct connection and refres...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi JAnder ,

     

     It looks like scheduled refresh failed because at least one data source is missing credentials. 
     To start the refresh again, go to this dataset's settings page and enter credentials for all data sources.

    According to your statement, please make sure you have configured credentials of your data source correctly in Power BI Service. If your data source need gateway to refresh, please add the credential to data source in gateway.

    Configure scheduled refresh

    Add or remove a gateway data source

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JAnder's avatar
JAnder
Icon for Helper II rankHelper II
4 years ago

Hi Anonymous 

 

Thanks for responding. This is all being done via the API so logging in and doing it using the Power BI portal is not really an option. The data source already exists and is in use elsewhere though, so I am confident the credentials are OK.

 

The problem seems to be  because I am uploading a pbix and switching the datasource connection string using the API, which uses the Service Principal. The service principal takes ownership and then cannot refresh. If I was to login and "take over" the dataset with an admin account it would refresh ok.

 

I am looking for ideas how to handle that with the API. The answer may just be I cant use the principal and need a master user?