Access DB with ODBC Connection Causing issue

[ahmed001]

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?

[ahmed001 · Accepted solution]

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