Forum Discussion

psheridan's avatar
psheridan
Icon for Advocate IV rankAdvocate IV
9 years ago

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...
Need Help
psheridan's avatar
psheridan
Icon for Advocate IV rankAdvocate IV
9 years ago

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?

hweaves12's avatar
hweaves12
Frequent Visitor
9 years ago

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.

 

  • psheridan's avatar
    psheridan
    Icon for Advocate IV rankAdvocate IV
    9 years ago
    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.
    • hweaves12's avatar
      hweaves12
      Frequent Visitor
      9 years ago

      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.

       

      https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-proxy/