Forum Discussion
Unable to connect to Azure SQL Server via Direct Query
Hi there, thanks for your help! I found out that the actual issue was related to a setting that we have for datasource connections called Use SSO via Azure AD for DirectQuery queries. This was unintentionally turned on and after switching it off, the data is now loading in my report.
For anyone else who might stumble into this issue, here are the steps for the above soln:
- Go to powerbi service settings(gear icon on top right)
- Go to manage connections and gateways inside the sidepanel
- Find your datasource for which you are getting this issue, click on 3 dot icon beside it -> settings -> uncheck the SSO checkbox
Hey there!
Azure SQL has a firewall that might be blocking Power BI Service’s IP addresses. If the Power BI service IP range changed, the connection might fail.
To fix this, try:
- Go to Azure Portal → SQL Server.
- Navigate to Networking → Firewall and Virtual Networks.
- Ensure "Allow Azure services and resources to access this server" is enabled.
- Add Power BI IP addresses from this list: Microsoft Power BI IP Ranges
The problem also may be specific to Power BI Service.
Fix:
- Open Power BI Desktop.
- Try reconnecting to the same Azure SQL Server using DirectQuery.
- If it works in Desktop but not in Service, the issue is with Power BI Gateway or Service Credentials.
Hope this helps!
😁😁