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.
In your PowerBI Desktop, rather than set your data source as the Gateway, set it as you normally would as if you aren't using the gateway. When you publish it into the web, your gateway will correctly see the database and bridge the connection for you.