Forum Discussion
Authentication failed after unpivot
I have connected to a set of data successfully from a SharePoint list via the "Get Data" menu. However, whenever I tried to Unpivot some columns, I would get an authentication error asking me to edi...
My colleagues found the solution!
Select SharePoint Online List, rather than SharePoint List.
Then select 2.0 rather than 1.0
By doing above two steps, unpivot will work smoothly, without the issue of "We couldn't authenticate with the credential provided..."