Forum Discussion

SharePointAU's avatar
SharePointAU
Frequent Visitor
8 years ago

Failed to update data source credentials, using Windows Auth for on-premise SharePoint List

I have a Power Bi desktop file using a dataset from SharePoint on-premise. It is published in a Teams workspace and i'm trying to schedule refresh, but it keep throwing an error "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." 

 

Then upon "editing credentials" we are met with another failure. 

Any suggestions on how to fix this? or Is there a better way to do what I'm doing?

Need Help
Tutorial Requests

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi SharePointAU,

     

    By my test, you could select the third Authentication method——OAuth2 to have a try.

     

     

    Best regards,

    Cherry

    • SharePointAU's avatar
      SharePointAU
      Frequent Visitor
      8 years ago

      Thanks for the reply.

      When I edit credientials I'm only given "Anonymous" and "Windows" as options, and for me they both fail.

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi SharePointAU,

         

        For your scenario, it seems that you could get data from on-premise Sharepoint list successfully.

         

        What crediential do you choose when you get data from on-premise SharePoint list in Power BI Desktop?

         

        Normally, we always choose Windows Authentication when the data source is on-premise SharePoint list, so if you choose windows authentication in Power BI Desktop, you should also choose Windows Authentication in Power BI Service.

         

        For the error you have encounterd, does the on-premise Gateway run on the same server which hosts the SharePoint?  Please check it.

         

        Best Regards,

        Cherry