Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to automate the data refresh process using Azure SQL database.
I found this article online, but I am not sure how I could get the option (AzureSQLDB) under Datasets from app.powerbi.com.
https://radacad.com/power-bi-get-data-from-azure-sql-database
Is it anything to do with License issue or something I need to configure in Power BI Desktop first?
Solved! Go to Solution.
You don't need to run Power BI Desktop in administration mode. It should work totally fine even when you open it in standard user mode. And the issue seems more of like firewall issue as you mentioned.
Please check if the following community forum helps you
https://community.powerbi.com/t5/Power-Query/SQL-Connection-Named-Pipes-Provider-error-40/m-p/194296
Did I answer your questions? Give a thumbs up and accept this post as solution!
I entered c9vis810ce based on this page.
Then, I got this error message.
Is it anything to do with network issue (firewall) or whether I need to run Power BI desktop as administrator?
You don't need to run Power BI Desktop in administration mode. It should work totally fine even when you open it in standard user mode. And the issue seems more of like firewall issue as you mentioned.
Please check if the following community forum helps you
https://community.powerbi.com/t5/Power-Query/SQL-Connection-Named-Pipes-Provider-error-40/m-p/194296
Did I answer your questions? Give a thumbs up and accept this post as solution!
It's nothing to do with the licenses. It's just that dataset is something that you create first, either in Power BI Desktop or in Service, and then set up schedule refresh.
Follow the below instructions to connect to Azure SQL Database
Power Query Azure SQL database connector | Microsoft Docs
Did I answer your questions? Give a thumbs up and accept this post as solution!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
20 | |
18 | |
14 | |
11 |
User | Count |
---|---|
32 | |
20 | |
19 | |
18 | |
11 |