Forum Discussion
Port range to Connect PowerBI Desktop to Azure SQL PaaS service
Hi Sparrow147,
To access Azure SQL Database from your local computer, ensure the firewall on your network and local computer allows outgoing communication on TCP port 1433.
References:
Azure SQL Database with DirectQuery
Configure Azure SQL Database firewall rules
Regards
Microsoft EmployeeHi Sparrow147,
To access Azure SQL Database from your local computer, ensure the firewall on your network and local computer allows outgoing communication on TCP port 1433.
References:
Azure SQL Database with DirectQuery
Configure Azure SQL Database firewall rules
Regards
Does Azure provide tooling for end-users to access SQL PaaS data from within the Azure portal which eliminates the need for connectivity between the desktop and the SQL PaaS environment? We have had a look at Power BI, but will need the Power BI Pro Desktop version if we want to define the relations within the database tables. We are wondering whether the Power BI version within the Azure Portal might eliminate the need for using the Desktop version.
Werner
- v-ljerr-msft
Hi Sparrow147,
Does Azure provide tooling for end-users to access SQL PaaS data from within the Azure portal which eliminates the need for connectivity between the desktop and the SQL PaaS environment?
As I am not very familiar with Azure portal, I would suggest you also go to Azure forums for better assistance on this issue.:smileyhappy:
Regards