Forum Discussion
Nested ODBC and Data Gateway
I am using a nested ODBC [ PBI --ODBC--> Access --ODBC--> Company DB ] to pull data into PBI. When I try to set up a scheduled refresh I get the following error: Underlying error code: -214746725...
Anonymous
Yes, I am using ODBC (through DNS) to connect to the Company DBs in Access. Under normal circumstances I would, however, company policy has not approved Power BI as an acceptable program to connect directly to our DBs. With regards to your second query, Access does not have native support with the Enterprise Gateway.
Thanks
Additionally, both company DBs run on 32 bit architecture. This may also cause the failures I'm experiencing.