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

As an update to this issue, as of now I'm able to connect successfully to data sources using by simply specifying the data source name (DSN=) in the connection string.

 

I'm not sure what caused these problems I experienced, however, I reinstalled the on-premises gateway back when I had this issue and it seemed to start working.

 

I'd say if you want to keep your ODBC data sources simple to use, specify the table directory and ensure you're using a 64-bit System DSN.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

My solution to this in the end was that the dataset was using CSVs, which weren't pointed to under the data gateway.

 

Once I did this I was able to use on-premises, basically make sure all your data sources are referenced under your gateway settings.