Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Folks,
I have created an Azure SQL Database that I am trying to connect my Power BI Desktop to. I don't have admin privileges on my laptop so can't install SSMS or open an outoging firewall port for 1433. The error I am getting:
I have opened the firewall setting on Azure for my IP Address. From my research on this forum I am suspecting that my companies network folk may need to open something but have no idea what to ask them, and this suspicion could very well be wrong on my part. it could even be that I only need to open an outgoing firewal for port 1433 on my laptop which i can request to be done from the service desk.
Any thoughts on where to look would apprecaited.
Regards
Binway
I have spoken to our network folk and they are going to put some monitoring in place from the Laptop to the Azure SQL Database. Then we will try to connect from the Power BI Desktop and get some results from the network monitoring. Ill let you know of the results.
Binway
Hi @Binway,
It sounds like a known issue which list on support page, I'd like to suggest you take a look on it:
Instead of receiving a message to enter credentials, customers using a Direct Query Model that connects to a SQL Azure data source will receive a pop-up "Couldn't load the schema for the database model" error message when opening the report if their SQL Azure credentials are incorrect. To fix the credentials, please go to dataset settings page and enter the correct credentials. Engineers are working on a fix and expect it to be deployed to all regions by end-of-day 12/03/18. |
---|
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
76 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
82 | |
61 | |
61 | |
60 |