Auto refresh is failing with you must use multi-factor authentication to access

[RameshPachunuri]

PowerBI reports are failing while auto refreshing and below is the error.

There is no option called multifafactor authentication in the "Data Source Credentials" to fix the issue. All I can see is only one option called.

Error:

Last refresh failed: 6/28/2024, 10:53:17 AM
There was an error when processing the data in the dataset.Hide details

Data source error:	{"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access '2746ea77-4702-4b45-80ca-3c97e680e8b7'. Trace ID: 2be93f43-f71e-42e1-8e7c-6cbfc8272500 Correlation ID: 27e878b8-30ff-44a6-9867-bb75620bc7e8 Timestamp: 2024-06-28 05:23:17Z"}}],"exceptionCulprit":1}}} Table: Releases.
Cluster URI:	DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:	1c7ed0f8-13df-cb84-cc4c-c2a6362c43d8
Request ID:	48286d4c-44ff-9349-b9dc-37ef0e892f55
Time:	2024-06-28 05:23:17Z

[Anonymous · Accepted solution]

Hi @RameshPachunuri 

To resolve the error, you can follow these steps:

1. Enable MFA for Power BI Service:

Here is a tutorial about how to enable MFA:

Enable Microsoft Entra multifactor authentication - Microsoft Entra ID | Microsoft Learn

Since the error mentions a configuration change made by your administrator, it might be helpful to contact them to ensure that your account is set up correctly for MFA.

2. Consider using a Service Principal:

Instead of using a user account, you can create a service principal with application permissions in Azure AD and use it for data refresh.
Here's how to create and use a service principal:

Use service principals & managed identities - Azure DevOps | Microsoft Learn

Best Regards

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