cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahmed001 Frequent Visitor
Frequent Visitor

Access DB with ODBC Connection Causing issue

I have an accessDB which using ODBC connection to SQL and used in queries.
Tried to use the queries to create a report on PowerBi, Issue is whenever I tried to update the dataset it gives me ODBC--call failed.

Tried created the ODBC connection on gateway machine. they are all 32 bit [ODBC/Power Bi Desktop] etc.

Can someone please help?

1 ACCEPTED SOLUTION

Accepted Solutions
ahmed001 Frequent Visitor
Frequent Visitor

Re: Access DB with ODBC Connection Causing issue

I figured out, Had to refresh all the linked tables/views in the access db from the gateway machine and everything works fine.

 

also had to install office 64bit with access driver 64 bit

1 REPLY 1
ahmed001 Frequent Visitor
Frequent Visitor

Re: Access DB with ODBC Connection Causing issue

I figured out, Had to refresh all the linked tables/views in the access db from the gateway machine and everything works fine.

 

also had to install office 64bit with access driver 64 bit