Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have been expericing the issue in refreshing data set.
It is happening from both 'Scheduled' and 'On Demand'.
Stragenly, it seems working fine in the first 1 or 2 hours, and then it stops working with the 'Invalid Credential' error message.
As seen from the screeen capture, when refresh finish around 1 hour, it completes successfully. but it goes more than 2 hours. then it fails. So now I suspect it might be caued by the token life length of the AD account that is used to connect to Dyanmics CRM (only data source).
Could it be the cause of the issue? Or maybe something else?
Solved! Go to Solution.
Hi @daniel-song,
The issue should be related to MFA (Multi-factor Authentication) for OAuth. I got internal information that at the end of this week, MFA (Multi-factor Authentication) for OAuth will be enabled for all clusters.
Would you please test again at that time and let me know the results?
Best Regards,
Qiuyun Yu
Hi Qiuyun Yu,
This week's test is successful.
Thank you for your support.
Daniel
Hi @daniel-song,
Thanks for your update. As the issue is gone now, I will close this thread.
Best Regards,
Qiuyun Yu
Hi Qiuyun Yu,
This week's test is successful.
Thank you for your support.
Daniel
Hi Qiuyun Yu,
Thank you for response and I will test it next week and post the outcome here.
And re. your questions in your previous post.
- Please go to dataset settings-> Data source credentials, enter the credential again then to see if you can refresh. (I tried it and manual refresh failed)
- Please download a copy and open in Power BI desktop to refresh data to see if issue only happens in Power BI service. (I can complete refresh with Power BI Desktop successfully)
Regards,
Daniel Song
Hi @daniel-song,
The issue should be related to MFA (Multi-factor Authentication) for OAuth. I got internal information that at the end of this week, MFA (Multi-factor Authentication) for OAuth will be enabled for all clusters.
Would you please test again at that time and let me know the results?
Best Regards,
Qiuyun Yu
Hi @daniel-song,
Please go to dataset settings-> Data source credentials, enter the credential again then to see if you can refresh.
Please download a copy and open in Power BI desktop to refresh data to see if issue only happens in Power BI service.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.