Connect to SQL server with Public IP

[sam7_976]

Hi,

I have power BI desktop file connected to SQL server, this SQL Server instance is installed on a server with Public IP and accessable everywhere.

After I published it on PowerBI.com, i was unable to refresh the dataset nor setting the scheduled refresh and it is asking to install the gatway.

my question here do i still need the gateway even if my SQL server accessable?? or i did some mistake??

thank you

[venal · Accepted solution]

@sam7_976 

As the data source hosted on-presmises server, Gateway is required for refresh.

Please refer the below documents for reference.

https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/service-gateway-data-sources#add-a-data-source

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @

BR

venal.

[venal]

@sam7_976 Thank you.