Forum Discussion

JAnder's avatar
JAnder
Helper 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.

bhushant's avatar
bhushant
Frequent Visitor
4 years ago

Hi JAnder  and Anonymous  -

I am trying to solve similar problem. please let me know if you have found a workaround or solution

Please see my use-case below

Use Service Principal to connect Data Source [ Azure SQL DB , Azure Databricks Delta Lake]

  1. When the PBIX is published to wokspace, using REST API - Takeover is performed and ownership is transfered to Service Principal [with admin access to workspace] [Ref: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/take-over-in-group]
  2. After Takeover, the Data Source credentials are required to be refreshed as well, as we are using Service Principal we have first obtain a Token and then using REST API authenticate Credentials - https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource#oauth-2.0-credentials-example
  3. After this Step - Embedded Report starts working and connection to Dat Source is sucessfull , but after the Token expiry the Report stops working 

Please can you let me know

  • if these are the right steps to Authenticate / Update Credentials of Service Principal ?
  • Any other workaround to use Service Principal based Authentication to Data Source from PBI-Embedded 

 

Appreciate your help, Many Thanks