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.

     

linas's avatar
linas
Frequent Visitor
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

    I'm trying this solution though i'm unsure what my databasename= is, would it be the name of the folder that my .dbf files are located in?

     

    I'm not sure if this is included in the dbq= string or not either?

     

    I'm having the same issue as described in your topic but i'm not using PostgreSQL, i'm using Microsoft Access dBase driver, i've created a System DSN that points to the dbf directory as well.