Forum Discussion

sapriorebw's avatar
sapriorebw
New Member
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

sapriorebw,

Do you use ODBC database option to connect to Company DB in Access? If so, why not directly create DSN for the company DB and connect to this data source in Power BI Desktop?

Also, why not directly use Access database connector in Power BI Desktop to connect to the Access data source?

Regards,
Lydia

  • sapriorebw's avatar
    sapriorebw
    New Member
    8 years ago

    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 

    • sapriorebw's avatar
      sapriorebw
      New Member
      8 years ago

      Additionally, both company DBs run on 32 bit architecture. This may also cause the failures I'm experiencing.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      sapriorebw，

      For the second option, you can use personal mode gateway instead, and ensure that you install 64 bit Access driver in the gateway machine.

      Regards,
      Lydia