Forum Discussion
Move from On Premise SQL to Azure SQL db - still needs on-premise gateway
Hi djillbunters ,
For Azure SQL databases, the refresh scenario does not require a local data gateway because Azure SQL databases are a cloud service. However, make sure that the dataset in Power BI Services is set to use a direct query connection to the Azure SQL database.
In Power BI Services, go to Dataset Settings and check the data source credentials. Make sure it is set to use the appropriate authentication method (e.g. OAuth2) for the Azure SQL database.
Also note: To connect to an Azure SQL database using DirectQuery, you must use Power BI Desktop and then publish the created report to the Power BI service.
For more details, you can read below document:
Azure SQL Database with DirectQuery - Power BI | Microsoft Learn
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A slight correction Anonymous .
In case if the Azure SQL database and its server is hosted within a VNaet; you would need a gateway to connect the Azure SQL database from Powerbi.
No need of gateway is Azure SQL database is hosted normally on Azure cloud service.