Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Unable 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??







Frequent Visitor

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.




Thanks - 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.



Yes, I have the gateway on a desktop that I keep on. Uninstalled both personal on on-prem and rebooted then reinstalled on-prem. The service recognizes the gateway has been added but still cannot connect in to any datasources (I have tried, files, folders, SQL, etc.). Even checked the firewall/proxy and no issues there...


I have an extended Pro trial, thinking maybe you need to have a paid subscription for this to work?

Is your PC part of a domain ?

It may be your authentication thats the problem.

If your connecting to a PC on the domain then the dataset should use windows authentication Domain/User and password.


Thank you for your persistence in helping! I am completely at a loss...I have tried all combinations of my domain and username - connecting to SQL, files, folders...nothing.

I've only used the on premise gateway and it worked first time for me, so Im reaching the total extent of my knowledge Im afraid!!!


I take it when you go online and check the gateway settings you are set up as the gateway administrator ?


An online search revealed this article perhaps it might help.



Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors