Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Unable to preview the tables when using ODBC connection

Hi,

An Apache Ignite ODBC driver has been configured in our remote desktop and tried connecting it to the Power BI where we have encountered with an error message as 'Table not found' while previewing the data.

 

Could you please help us on this.

 

Regards

Siva

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

If you cannot find the table, maybe the 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.

More reference:

How to Connect to an ODBC Data Source From Power B... - Microsoft Power BI Community

ODBC Connection Error - Driver Error - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ kalyj

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.