Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
JustinDoh1
Post Prodigy
Post Prodigy

Trying to connect to Azure SQL DB from PowerBI.com

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

Image1.png

Is it anything to do with License issue or something I need to configure in Power BI Desktop first?

 

1 ACCEPTED SOLUTION

@JustinDoh1 

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!

View solution in original post

3 REPLIES 3
JustinDoh1
Post Prodigy
Post Prodigy

@_sfrost 

I entered c9vis810ce based on this page.

ServerName.png

 

SQLServerDatabase.png

 

Then, I got this error message.

UnableToConnect.png

 

Is it anything to do with network issue (firewall) or whether I need to run Power BI desktop as administrator?

@JustinDoh1 

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!

_sfrost
Solution Specialist
Solution Specialist

@JustinDoh1 

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

  • Open Power BI Desktop
  • Click on Get Data 
  • Select SQL Server Database and follow the below article

Power Query Azure SQL database connector | Microsoft Docs

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.