Forum Discussion

linas's avatar
linas
Frequent Visitor
9 years ago
Solved

DataSet cannot see On-Premises Data Gateway

I have: 1. On-Premises Data Gateway which has an ODBC (driver={PostgreSQL Unicode(x64)}) Data Source added. (Test All Connections works well) 2. PowerBI desktop file which has a DataSet added (GetD...
Need Help
  • linas's avatar
    linas
    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.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

linas Do you have any other data sources in the Desktop file other than the ODBC one?

Do you have the latest versions of the gateways?

linas's avatar
linas
Frequent Visitor
9 years ago

Anonymous Correct, a single DataSource. Gateway is downloaded from powerbi.com today, I assume it should be latest (Service Properties tab shows Product Version 14.16.6228.1)