PowerBI Service Issue with Scheduled refresh failed

[Anonymous]

An error occurred while processing the data in the semantic model.

Refresh failed:

PowerBIDashboard has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The credentials provided for the SQL source are invalid. ("Connecting using Managed Identity"). The exception was raised by the IDbCommand interface. Table : xyz

[v-saisrao-msft]

Hi @Anonymous,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Anonymous,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[lbendlin]

Is this on-premise, Azure, or Fabric SQL ?

[Anonymous]

This is Azure SQL

[v-saisrao-msft · Accepted solution]

Hi @Anonymous,

Thank you for reaching out to the Microsoft Fabric Forum Community. 

The error suggests an authentication failure when Power BI attempts to connect to the SQL source using Managed Identity.  

To resolve this, first, ensure that Managed Identity is properly enabled in Power BI and correctly configured in Azure SQL. Next, verify that the Managed Identity has the necessary permissions to access the database. If needed, involve your database administrator to confirm the required access.  

Additionally, check Power BI Service settings under Settings → Data Sources to ensure the authentication mode is correctly set to Managed Identity. It’s also important to validate Azure SQL Firewall settings to confirm that Power BI service IPs are allowed. After making these checks, try manually refreshing the dataset. 

Please refer the below link for more understanding: 

Troubleshoot scheduled refresh for Azure SQL databases - Power BI | Microsoft Learn.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.