Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a set of data which is input into a Sharepoint list, for which I have constructed reports against using PowerBI desktop.
Once finalised, I published the data to app.powerbi.com under my workspace, but now it is unable to refresh.
It's using the same connection credentials as I did in desktop (Office365 account) but does not seem to want to work.
Have run out of ideas. Any help greatly appreciated.
Solved! Go to Solution.
@mebden,
Do you connect to SharePoint Online list in Power BI? If so, I test the scenario as yours and I can successfully enter credential and refresh the dataset in Power BI Service.
Have you enabled Multi-factor authentication(MFA) in your environment? If so, the above error will throw in this case and this behavior is by design. The workaround is to disable the MFA for the account.
Regards,
Lydia
@mebden,
Do you connect to SharePoint Online list in Power BI? If so, I test the scenario as yours and I can successfully enter credential and refresh the dataset in Power BI Service.
Have you enabled Multi-factor authentication(MFA) in your environment? If so, the above error will throw in this case and this behavior is by design. The workaround is to disable the MFA for the account.
Regards,
Lydia
@v-yuezhe-msft wrote:@mebden,
Do you connect to SharePoint Online list in Power BI? If so, I test the scenario as yours and I can successfully enter credential and refresh the dataset in Power BI Service.
Have you enabled Multi-factor authentication(MFA) in your environment? If so, the above error will throw in this case and this behavior is by design. The workaround is to disable the MFA for the account.
Regards,
Lydia
When you say 'disable the MFA for the account' - which account ar you referring to?
I have the same issue and every combination of the options below gives me an error. Are there no other options here?
Yes, we are using MFA per Microsoft security recommended design for Office 365.
So having MFA not permitted seems a little short-sighted.
Would it work if we used App passwords instead? Or is this not going to work when pulling any type of data from a Sharepoint backend?
We need to use OAuth auth type to connect to SharePoint Online. The temporary solution in your scenario is to disable MFA.
Meanwhile, you can vote up this idea.
Regards,
Lydia