Forum Discussion

svandamme's avatar
svandamme
Frequent Visitor
9 years ago
Solved

Gateway Error ODBC

  Hi,   I have an Excel that is linked to the database via ODBC. I published the PowerPivot data model in Power BI desktop and published it to Power BI. I installed the enterprise gateway on my co...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi svandamme,

     

    Power BI doens't have 32 bit data gateway now. From your description, it seems that your DSN is 32 bit, I think that should be the issue. Please try to create a 64 bit ODBC DSN, then add a data source under data gateway to see if the same issue occur.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi svandamme,

 

Power BI doens't have 32 bit data gateway now. From your description, it seems that your DSN is 32 bit, I think that should be the issue. Please try to create a 64 bit ODBC DSN, then add a data source under data gateway to see if the same issue occur.

 

Best Regards,
Qiuyun Yu

svandamme's avatar
svandamme
Frequent Visitor
9 years ago

Thank you for your response. I will take it up with IT and see if a 64 bit ODBC driver won't have consequences because all our applications use 32-bit.