Hi Fredrik,
Few things to explain before answering your questions below:
- In order to start using the Enterprise gateway, you need to go to Manage Gateway page and add your SQL server connection there, where you add server,DB name and your credentials that you want to use. Now after you do that you can go to your dataset again and the Enterprise Gateway should show up. Make sure that the data source information you add under the gateway matches exactly what you have on that dataset. No additional work needed to move to using from the Personal Gateway to the enterprise one. More info can be found here: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
- "Manage Gateways" UI will only show the enterprise gateways, it doesn't show the personal gateway, since you could only have one.
- You are right: there is no way to move from using the personal gateway to the enterprise one. The only way to do it is to add the data sources to the new enterprise gateway one by one.
To your questions:
A) Why is the "use an enterprise gateway" option disabled although it is installed, configured and working OK
- you need to add the data source from manage gateways.
B) Is the only option to move from PG to EG really to delete all the datasets?
- You do not have to delete the datasets, just make sure the server name and DB name match 100% between the data source you add under the gateway and the ones you used to establish the connection in your report.
C) Is there ANY reason nowadays to use the PG over the EG?
- Yes, use cases are different: in the personal gateway you can run it on your personal laptop without having to be an admin on that machine, you can use one gateway for all your datasets. The downside is you cannot share the gateway, you cannot have a centralized control, and you cannot establish a direct query in the persona gateway.
