Forum Discussion
kiteboy
4 years agoNew Member
ODBC Connection Table Not Found
Hi all First time really trying to use PowerBI. I have set it up to connect to a database and the table names do populate and I can see the username logging in and out of the database itself - so...
v-yalanwu-msft
4 years agoCommunity Support
Hi, kiteboy ;
If you cannot find the table, if a link points to an external file that does not exist, or if the external file has been moved to a new location. This error can also occur if a deleted or renamed table or query is referenced on the Lookup tab of another table.
To troubleshoot this behavior, do the following:
- Check to ensure that the table or query exists. If it does not exist, you can remove all references to it, or if it is a missing table, reimport or relink the table. If it is a missing query, reimport or re-create the query.
- When you try to open the source table may not be in the path that you specified when it was first . If you have moved the file, you can use the Linked Table Manager to update the information.
https://community.powerbi.com/t5/Power-Query/ODBC-Connection-Error-Driver-Error/td-p/163517
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.