Forum Discussion
Getting errors after changing data sources and trying to apply changes
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
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.
2 Replies
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.