Forum Discussion
DataSet cannot see On-Premises Data Gateway
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.
Thanks for your reply. I think that is exactly how I'm using PowerBI desktop. I'm quite new to PowerBI, sorry if I'm using incorrect terms here, but when I create my DataSet in PowerBI Desktop I simply click GetData -> ODBC, and tchen fill in my PostgreSQL connection details (again - DSN, Connection String and Authentication details match the ones on Data Gateway's setup PowerBI.com). And I think I don't even have an option to select like 'Gateway' in PowerBI desktop, unless it is hidden under different name.