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 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.

  • 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

5 Replies

  • 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

    • DerekTrujillo's avatar
      DerekTrujillo
      Frequent Visitor
      7 years ago
      Anonymous 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?

      • DerekTrujillo's avatar
        DerekTrujillo
        Frequent Visitor
        7 years ago

         

        I have the same issue and every combination of the options below gives me an error. Are there no other options here? Data Source Configuration - Power BI