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.
Ik have the same problem here with a Pervasive ODBC connection.
In Power BI I have only one datasource (only the ODBC connection).
I have the latest Power BI Data Gateway and a succefull connection on Power BI Service gateway.
But; if i publish my report, the dataset will not connect to the gateway. :-(
In Power BI Desktop I have created a connection with the DSN.
The gateway on Power BI Service uses a connection string like "Driver={driver};ServerName=server;dbq=database".
I tried to use this connection string in Power BI Desktop, but it won't connect in Power BI Service.
I hope someone could help us! Thnx.
Have you tried going to the gear at the top right of the screen and clicking "Manage Gateway"? From there you would add the data source by filling in the information. In addition, this is where you would find the data source to see if there is a reason the gateway is not finding it. Errors show up as yellow caution signs after the data set name. Then, when you click on the dataset, it will give more information. My most frequent error is that the mashup container failed to connect. Still working on that error with Microsoft. support.
If it is still causing problems, verify the connection string through the advanced editor in the desktop.