Forum Discussion
PowerBI gateway
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.
Super User I installed a gateway in the server I mentioned previouslyPlease do not install a gateway on a machine that is already running something else. Gateways need dedicated machines.
In your Power BI report connect to the SQL database on that SQL server (not to your local database). Then in the gateway cloud management interface create exactly the same connection. Then publish your report to the workspace and link the semantic model to the gateway. After that you can enable scheduled refreshes.
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.
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.
- lbendlin
Gatway will automatically connect to powerbi Service using standard port 80.not for a long time. Nowadays everything is exclusively 443.
