Data Gateway not allowing me update connections or to apply changes

[bhickok]

In multiple clients the apply button on the data gateway cloud connections is grayed out after adding a dataverse connector. Also when I configure a connection with an onprem gateway the setting never update to the gateway connections even though they save in the manage connections and gateways page.

[bhickok · Accepted solution]

So here is my resolve after alot of troubleshooting. Thanks to this article I realized that when I make an ODBC connection on the Power BI Desktop and publish it there is no way to change the connection string once it is published. Thus my problem was that the connection string was different on the machine I was developing on from the Data Gateway Machine that I was attempting to connect to in the cloud. Once I realized I needed to utilize a parameter it was super simple. Just add a parameter with the connection string in it, change the source of the data to reference the parameter, and then after publishing go into the semantic model settings and update the connection string to the correct value. 

Note: You cannot use ANY as an option on the parameter and be able to change it once it is published. 

[v-xiaoyan-msft]

Hi @bhickok ,

If you manually refresh via Power BI Desktop is it possible to refresh successfully?
Also, have you checked that your gateway is at the latest version?

Best regards.
Community Support Team_ Caitlyn

[bhickok]

Hi Team_ Caitlyn,  I do have the latest gateway installed. If i'm in the network I can connect to the odbc and refresh without issue. Under the Gateway Connections it shows the Not Configured Correctly. I think I pin pointed where my issue is. When I created the report I was on a machine that was within the network and I utilized the OBDC connector on that machine to connect to the data source on another machine. When I can to publish the report and try to utilize the gateway it is trying to use the dsn from the machine I set it up on instead of allowing me to swap it to the gateway dsn. I'm not sure how to fix that though.

[lbendlin]

both the dsn name and the definition MUST match EXACTLY between desktop and gateway. Even that is not a guarantee. I remember we had a ticket where the product team acknowledged that they were randomly re-ordering the ODBC connection string in the service (!!!)

[lbendlin]

You can't have spaces in a dsn.

[bhickok]

Thanks lbendlin for the idea. Unfortunately my actual dsn doesn't contain a space. I've also tested my dsn, driver etc, from a power by odbc connection and it works great within the network.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .