Forum Discussion
Schedule refresh - gateway
Anonymous,
Which type of gateway does the DBA install for you, on-premises gateway or personal gateway?
If the DBA installs on-premises gateway , he should go to the administrator’s tab of the registered gateway to add you as additional admin, then you will be able to see gateway in "Manage gateway", and you are able to add all data sources within the gateway.
Regards,
Lydia Zhang
Anonymous,
Which type of gateway does the DBA install for you, on-premises gateway or personal gateway?
If the DBA installs on-premises gateway , he should go to the administrator’s tab of the registered gateway to add you as additional admin, then you will be able to see gateway in "Manage gateway", and you are able to add all data sources within the gateway.
Regards,
Lydia Zhang
I am having the same issue with an Enterprise (on premises) gateway. I have been added as an admin for the gateway, it is on a server that is available 24/7, and I've added the databases to the gateway and connected to them without issue from the Gateway Settings.
But when I try to setup a scheduled refresh on my Datasets to the gateway and associated data sources, the credentials cannot be verified. It never "fails", the login pop-up remains and spins forever (5+ mins).
I am using the same credentials and authentication method as the data source connections within the gateway.
I'm at a total loss how to solve this other than to either install a personal gateway (redundant) or to complete wipe out my .pbix files and start over (huge effort).
Any insights are appreciated!
Thanks GilbertQ, I will give both of your suggestions a try and circle back.
I just installed the Enterprise Gateway current version on my local machine (laptop)... it is still not visible in the dataset gateway connection settings.
Then I installed the Personal Gateway current version on my laptop... and it is visible! All data sources connect! But why does the Personal Gateway work and the Enterprise Gateway is invisible?
Observation: when I try to connect to data sources using the Enterprise Gateway, I am given two authentication methods: Basic and Windows. Neither option works.
When I try to connect to data sources using the Personal Gateway, the authentication choices are Basic and WindowsWithoutImpersonation. The second option works.
Why is this different authentication method only popping up on the Personal Gateway? Could this be a symptom of why the Enterprise Gateway is not visible? Searching on this authentication type doesn't provide much information.
Appreciate your help!
EDIT
Suddenly the Enterprise Gateway is visible. I didn't make any changes. It's been about an hour since I first connected... maybe Power BI takes a while to seek/refresh/connect with existing gateways?
I'm at a loss, but at least it is working (now).
- Awesome and yes due to it being a cloud service it can take a few minutes or possibly a bit more before everything is configured.
- I would suggest putting on the Verbose logging and see if you can see the connection making it to the Gateway server.
That should be a good starting point?
As well as ensuring that you have got the latest On-Premise Gateway installed? Hi rlien1
When you install the Gateway in the On-Premise mode it should ask you to Log into Power BI. Once that is done if you go under Settings you should then see Manage Gateways. It is from there where you configure your Gateways.
This will give you more information on how to install and configure them: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
