Schedule Refresh

[Nimai123]

We are trying to connect an azure on-premise SQL server which has the public endpoint, for report refreshing in the PowerBI Service but somehow it's asking for powerbi gateway, I don’t understand since we have an open public endpoint and we can connect the SQL server from anywhere, why is there a need for on-premises data gateway?

@amitchandak 

@parry2k 

@Greg_Deckler 

[amitchandak · Accepted solution]

@Nimai123 , refer : https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-public-endpoint-co...

https://radacad.com/power-bi-get-data-from-azure-sql-database

https://radacad.com/power-bi-get-data-from-azure-sql-database