Forum Discussion
Installed Gateway, shows online, trying to Create Datasource "Unexpected error" happens
Gateway shows up, says "Online: You are good to go." Type in everything and get this.... What's going on? Others are able to create the datasource but me using same information...
The gateway keys data source off of server name/database name...you can't have two connections to the same source in the gateway. A data souce only need be added once.
12 Replies
- GilbertQ
Super User
Hi there
Is your SQL Server On-Premise or on Azure?
If it is on-prem can you make sure that where you installed the Gateway that it can successfully connect to the database?- GilbertQWhich operating system are you running?
Also is there enough memory and CPU for both the SQL Server and the Gateway?
- Icey
Community Support
Hi Anonymous ,
Please check if you are the admin of the gateway. Please refer to this official document.
To use an on-premises data source in a dataflow, any user creating the dataflow must have an Enterprise Gateway installed and configured. The user creating the dataflow also must be the Enterprise Gateway's administrator in order to use that gateway for a dataflow.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- jeffshieldsdev
Solution Sage
The error just happens trying to create a new connection to SQL Server? The users it is working fine for are using other connections?
I have to enable HTTPS in the gateway config on the host computer in my company for it to work. You can also enabling logging in the gateway and see if there's more useful error messages in there: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot
- jeffshieldsdev
How are you trying to authenticate?
