Forum Discussion
Gateway connectivity issue
- 8 years ago
You need to add your sql data source in the power bi service
The following link may help you: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql
Make sure server, database name and credentials are as you have them in your power bi desktop file that was published
Good luck
You need to add your sql data source in the power bi service
The following link may help you: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql
Make sure server, database name and credentials are as you have them in your power bi desktop file that was published
Good luck
- kattlees8 years agoPost Patron
Tried that and still can't get it. Does the gateway have to be installed on the computer the desktop version is on? We installed it on a company server. Connection shows successful under Manage Gateways.
- kattlees8 years agoPost Patron
We figured it out. We don't have a gateway set up for the excel file we were accessing.
- blopez118 years agoSuper User
Oh yes, for every source you have configured in your pbix file, you must have configured in the service
That one has got me a couple of times
Good to hear you all are good to go