Forum Discussion
Advocate IVUnable to add Data Source to On-Prem Gateway in Service
upgraded my gateway and I am trying to add data sources in the service but after entering all info, when I click 'add' nothing happens. I have tried this for files, SQL server connections, etc...same for everything, nothing happens.
Gateway is installed on my desktop. Refreshes and connections to all these datasources worked fine before upgrading the gateway.
Tried username with and without my domain, Basic and Windows authentication, same connection as in the pbix files, etc... no clue where to look for help at this point, any ideas??
Thanks
7 Replies
I've had this before too, maybe a coincidence but stopping and starting the gateway service seemed to resolve it for me.
It only takes a couple of minutes so its worth a try.
It might also be worthwhile trying to add a data source to say a local excel/csv file that way it proves the gateway is working and its localised to your SQL connection.
psheridanThanks - tried stopping/starting and no luck when adding a file or SQL
Well that narrows down the problem to the gateway then.
Are you still running the gateway on your desktop?
It is recommended to install the gateway on say a server which is not likely to be off line often if at all.
The only other issues I have found are where you have the personal and on premises gateway installed on the same machine, this seems to cause problems.
I would do a belt and braces uninstall of the gateway then reboot and a reinstall if thats possible.
