Forum Discussion
charlesbatista2
1 year agoNew Member
PowerBI gateway
Hello, guys. Here's the issue: I have a database in a server where I have SQL server and MSSM installed, I don't have PowerBI Desktop installed in this server. I'm working on my PowerBI desktop w...
- 1 year ago
Your setup is not supported. Both your Power BI Desktop and the gateway must have direct line of sight to the on-premise data source.
charlesbatista2
1 year agoNew Member
I cannot connect the SQL server from that server to my Powerbi desktop because I cannot open ports of the server to connect it to my local PowerBI Desktop.
amjidali
1 year agoNew Member
Hi Charles,
I don't think It should be a complex setup, you don't need ot open the ports if you are using PowerBI on Server or Desktop. You jsut need to install the gateway. Gatway will automatically connect to powerbi Service using standard port 80. However if you are using Cloud Database then scenario is different.
- lbendlin1 year ago
Super User
Gatway will automatically connect to powerbi Service using standard port 80.not for a long time. Nowadays everything is exclusively 443.