Forum Discussion

AR_D's avatar
AR_D
Regular Visitor
6 months ago
Solved

Scheduled Refresh Fails When Password Is Changed (Fabric Lakehouse (using sql end pt) – Import Mode)

Hi Community,

I am facing an issue with scheduled refresh in Fabric Lakehouse (using sql endpoint) connected to Power BI (Import Mode) and would appreciate your guidance.

 

Scenario:

  • I created a Power BI report connected to a Fabric Lakehouse ( using sql endpoint) using Import Mode.

  • Published the report to Power BI Service.

  • Configured scheduled refresh by creating a new data source connection using organizational credentials (OAuth).

  • Refresh works fine initially.

 

Whenever the password of the account used for authentication is changed, the scheduled refresh fails in Power BI Service.

It seems the dataset is dependent on the user’s credentials, and any password update breaks the refresh.

 

What is the recommended best practice to avoid refresh failures when passwords change?
And  how to achieve this 

Thanku so much for your time

Need Help
Show and Tell
Tips and Tricks
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    The best practice is to use a service principal account. This accounts pass would never change and the ownership of your models stays in this.

3 Replies

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    6 months ago

    The best practice is to use a service principal account. This accounts pass would never change and the ownership of your models stays in this.

    • AR_D's avatar
      AR_D
      Regular Visitor
      6 months ago

      Hi cengizhanarslan 

      Just wanted to confirm that, who can create this service principal account
      Because I was trying to create but stuck in finding Allow service principals to use Power BI APIs (because this is not visible to me in power bi service.
      I was creating in azure and there I din't find below two option

      • Dataset.ReadWrite.All

      • Workspace.ReadWrite.All
        becasue of Allow service principals to use Power BI APIs  is not enabled and i am not able see this option in power bi service

      To create this the role should only 

       

      ✔ Global Administrator
      OR
      ✔ Power BI Service Administrator



      Just want to confirm this.

      Thanku so much for your time.

      • Wikkleyn_81's avatar
        Wikkleyn_81
        Icon for Super User rankSuper User
        6 months ago

        Hi AR_D The Power BI Admin should have the permission to grant those when you create the App in azure and enable the setting Allow service principals to use Power BI API.

         

        You can also make use of a Workspace Identity in Fabric as the authentication for the lakehouse cloud connection. 
        https://learn.microsoft.com/en-us/fabric/security/workspace-identity 

         

        The other option is to use a Service Account with a password that expires yearly/never. The Service Account requires permission to the workspace or the lakehouse