Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I can connect to and refresh data from my Azure database using Power BI desktop. I deploy the report to the portal, but am unable to enter the credentials to the same Azure database - it just hangs forever. Is there a firewall setting in Azure that needs to be enabled for Power Bi to access? This is an Import (not direct query).
I have other reports that connect to other Azure databases, with no issues.
Solved! Go to Solution.
Thanks for the suggestion. I opened a support ticket and was able to get it resolved. I was referencing the port number 1433 in my server name, which was working locally but not once it was deployed.
I can't reproduce your issue. I connect Azure databases (import mode) and publish it onto Power BI. I can edit the credential (Basic Authentication) properly. Ensure firewall rules for the Azure database are configured to "Allow access to Azure services". For more details, see: Azure SQL Database with DirectQuery.
Regards,
Thanks for the suggestion. I opened a support ticket and was able to get it resolved. I was referencing the port number 1433 in my server name, which was working locally but not once it was deployed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.