Forum Discussion
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...
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.
Okay, let me rephrase the question a bit:
Did anyone at any point of time manage to get a DataSet with underlying ODBC\PostgreSQL connection updated through Data Gateway? If so, would you be able to share steps?