Forum Discussion

linas's avatar
linas
Frequent Visitor
9 years ago
Solved

Bug: Windows PowerBI Desktop ODBC is incompatible with Data Gateway's ODBC

Couldn't find where to submit a bug, so I am forced to use this 'New Idea' button....   Anyway, details: Windows 10 (with all the latest updates) + PowerBI Desktop - latest. + ODBC Driver Postgr...
  • linas's avatar
    9 years ago

    Figured! Appareantly when working in PowerBI Desktop and creating a DataSet based on ODBC you must select '(None)' from the Data Source Name (DSN) dropdown and paste your connection string to 'Connection String' textbox under Advanced options section (see screenshot below).

     

    Again, make sure you use same connection string when adding a new DataSource under Gateway in your powerbi.com.