Authentication failed after unpivot

Question

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 edit credentials:

"We couldn't authenticate with the credentials provided. Please try again."

I have tried it with different columns and it doesn't seem to matter which I try to unpivot, I'd still get the same error. I am currently signed in to access the SharePoint list through Organization account.

stanley_liu2023 · Answer

My colleagues found the solution!Select SharePoint Online List, rather than SharePoint List.Then select 2.0 rather than 1.0&nbsp;By doing above two steps, unpivot will work smoothly, without the issue of "We couldn't authenticate with the credential provided..."&nbsp;&nbsp;

amitchandak · Answer

DEngLead , In the Datasource setting, Clear permission and then provide credentials and try again

denglead · Answer

Thanks for your reply.&nbsp; I have done that as suggested on this discussion, unfortunately the issue persisted.

v-easonf-msft · Answer

Hi,&nbsp;DEngLead&nbsp;
Clear permissions&nbsp;and try selecting top-level address of sharepoint url to apply authentication.
Set the level of the authentication method&nbsp;
&nbsp;
Best Regards,Community Support Team _ Eason

denglead · Answer

Thanks for the reply and suggestion.&nbsp; I am afraid I do not have the rights to access the top level address of the SharePoint URL.&nbsp; I can only access that one particular site.

Forum Discussion

Authentication failed after unpivot

8 Replies

Related content

Linked Server Authentication Fails

Pivot / Unpivot?

Unpivot Column

Microsoft Authenticator Authentication Failed

Unpivot Question