When changing data source I am receiving error 'we couldn't authenticate your details'

[dswallow]

I have created a dashboard but now want to have a live connection to my data source in excel. I have saved the excel as a one drive and am now trying to change the data source to make the connection. When doing this I am getting the error code 'We couldn't authenticate your details' when trying to apply the changes. I have about 4 credentials to chose from but all come back with the same error. Any advise would be must appreciated. Thanks!!

[v-angzheng-msft]

Hi, @dswallow 

May I ask if your problem has been solved? The method provided by amitchandak is a good attempt.

If it helps,  could you please mark the post which helps as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[amitchandak · Accepted solution]

@dswallow , first create a new connection in a new pbix file and see if you are able to get data. Then manually replace the table code in power query and try

refer for steps

How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY