Azure SQL forcing me to use a gateway

[fhfortech]

Hi guys, I have the following situation at work, I'm creating several dashboards in PBI, connected to an Azure SQL database but the only way is allowing me to refresh its via a Gateway Connection, but in my case this is not an option i need this to be continuously refreshing since the data is from a CRM/ERP which is on the cloud not locally install, is there any way i can do this without using a Gateway.

*BTW using the Gateway is working fine and refreshing but I cant keep this PC on just to refresh data

[v-xicai]

Hi  @fhfortech ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @fhfortech ,

If your dataset only contains Azure SQL database dataset, Power BI gateway is not required.

If your dataset contains not only Azure SQL database data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh , see more: :On-premises data gateway , Configure scheduled refresh . Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

>>*BTW using the Gateway is working fine and refreshing but I cant keep this PC on just to refresh data .

For this concern, recommend you install on premise data gateway (Enterprise gateway) instead of Personal gateway.

Then you can create high availability clusters of On-premises data gateway installations .The Power BI service always uses the primary gateway in the cluster, unless it’s not available. In that case, the service switches to the next gateway in the cluster, and so on.

You can see how to create gateway cluster: https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clusters , https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly