Forum Discussion
OLE DB or ODBC error: [DataSource.NotFound]
Data Source has not been moved or changed - Data Source still exists (SharePoint Online List) - Nothing has been removed from it
However when trying to refresh the dataset this is the error message I am getting
2 Replies
Hi BannanDylan - check if the credentials are missing or invalid, re-enter them (OAuth2 is recommended for SharePoint Online).
In Power query editor too check the data sources settings and url format is correct placed.In Power Query, look for errors in steps, and adjust transformations if needed.
HOpe the above detail helps.
Power Query SharePoint list connector - Power Query | Microsoft Learn
Hi,
Thanks for the solution rajendraongole1 offered, and i want to offer some more information for user to refer to.
hello BannanDylan , please check that if the data has been broken , it may cause the problem, and please make sure that you have the correct permission of the datasource, and you can refer the following similar thread.
Solved: Error returned: 'OLE DB or ODBC error: [Expression... - Microsoft Fabric Community
Solved: "OLE DB or ODBC error: [DataSource.NotFound]" when... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
