PowerBI Service Issue with Scheduled refresh failed

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.