Authentication failed after unpivot

[DEngLead]

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]

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

[Stanley_Liu2023]

Hi, @DEngLead did you solve the problem? I encouter the same... none of the solutions works.

[ncdsknvkdnfkvnf]

hi,have you solved  the problem? i have the same problem as you

[amitchandak]

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

[DEngLead]

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

[v-easonf-msft]

Hi, @DEngLead 

Clear permissions and try selecting top-level address of sharepoint url to apply authentication.

Set the level of the authentication method 

Best Regards,
Community Support Team _ Eason

[DEngLead]

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

[v-easonf-msft]

Hi, @DEngLead 

If you still have no idea about your problem and you’re a Power BI Pro customer, you can open a support ticket with MSFT to seek technical support , usually they will have better suggestions.

Best Regards,
Community Support Team _ Eason