Getting errors after changing data sources and trying to apply changes

[Anonymous]

Hi everyone, 

I have an established dashbaord on Power BI and have been updating it quarterly, using the change data source settings function to replace dataset. (Transform data -> Data source settings -> Change source -> copied the link to my dataset -> close) 

However, this time when I am uploading the latest dataset, it showed me errors (screenshot below) after I replaced the old dataset and tried to "Apply Changes". 

Another thing I don't understand is, everytime when I click on apply changes, it shows different messages/errors. Screenshot below. 

Do you know what might be the problem? My team and I have checked plenty of times that the tables/columns remain the same like the last quarter's dataset. So I can't figure out why it is not loading well this time. Would greatly appreciate your help! Thank you very much!! 

Best regards,

Emily

[Anonymous · Accepted solution]

Hi @Anonymous ,

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 to refer for steps:

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

You can refer to the following posts that may be helpful to you:

Solved: OLE DB or ODBC error: Exception from HRESULT: 0x80... - Microsoft Power BI Community

Solved: ERROR WHEN CHANGING DATA SOURCE - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Thank you! It turned out to be a data cleaning problem but these links were helpful