Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

The credentials provided for the SharePoint source are invalid.

For some reason when I update via app.powerbi.com I keep getting the error:    The credentials provided for the SharePoint source are invalid.    I have gone into the credentials section and chan...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi All,

     

    This issue has been fixed.

     

    Best Regards,
    Dale

AndyRath's avatar
AndyRath
Frequent Visitor
6 years ago

My Fix
I was having similar problems to those above, dataset was refreshing fine in Desktop but failing on the service even though credentials were correct....after hours of looking I found the problem was in my M Code (Power Query) (I actually had two of the same SharePoint data sources showing in 'Data Source Settings' (which should've given the game away)). 
https://xxxx.sharepoint.com/sites/xxxx
https://xxxx.sharepoint.com/Sites/xxxx
Now we all know M Code is case sensitive and having gone through each query ensuring each source was the same case (thus returning me to one Data Source) it immediately fixed the problem upon publishing.