Forum Discussion

mebden's avatar
mebden
New Member
9 years ago
Solved

Failed to update data source credentials when refreshing from Sharepoint list

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 wo...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
mebden
New Member
9 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    mebden,


    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