Forum Discussion
Getting errors after changing data sources and trying to apply changes
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.
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.
Thank you! It turned out to be a data cleaning problem but these links were helpful