01-14-2019 09:08 AM - edited 01-14-2019 09:09 AM
I have a report made in Desktop Power BI that I have published in the Power BI web/online. The connections to the data set I've used is ODBC on a personal gateway. I have then set-up an on-premise gatway with a connection to the same ODBC database which the "Test all connection" is showing is online.
However, when I am configuring the Gateway connection of the dataset that has been published, it is showing that none of the gateways (personal or on-premise) are working.
For on-premise, it is trying to find a connection that is in the Deskop dataset (i.e. dsn = as400pb) and not the on-premise gateway connection of dsn=as400 - production.
Any idea how to get around this, please?