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
prokurors
Advocate III
Advocate III

Creating Power BI report with data from Azure SQL using direct query - Power BI asks for Pro licence

Can I make reports (publish, share) from Azure SQL with Power BI free edition? https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/ From this post it seems that using Power BI with Azure SQL is only for Pro licence users? Is that really so? And if this requires Pro licence - is it for each user who needs to access this report, or is it only for the user who creates/publishes/shares this report?

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@prokurors I'll break it down for you.

 

No you don't need power bi pro to be able to use Azure SQL DB. How you setup your data refresh mechanism will depend on if you require Pro or Free.

 

Since you've posted this in Service forum, I am going to assume you will click Get Data in app.powerbi.com and connect to Azure SQL DB that way (You will need power bi pro for that because that will use DirectQuery to connect live to Azure SQL DB). With power bi free, you can connect to Azure SQL DB and build reports (using power bi desktop) but data refresh is once daily by itself. If you want to setup schedule refresh (max 8 times a day) you will need Pro account.

 

Hope that helps. Do let me know if it isn't clear.

 

 

View solution in original post

5 REPLIES 5
ankitpatira
Community Champion
Community Champion

@prokurors I'll break it down for you.

 

No you don't need power bi pro to be able to use Azure SQL DB. How you setup your data refresh mechanism will depend on if you require Pro or Free.

 

Since you've posted this in Service forum, I am going to assume you will click Get Data in app.powerbi.com and connect to Azure SQL DB that way (You will need power bi pro for that because that will use DirectQuery to connect live to Azure SQL DB). With power bi free, you can connect to Azure SQL DB and build reports (using power bi desktop) but data refresh is once daily by itself. If you want to setup schedule refresh (max 8 times a day) you will need Pro account.

 

Hope that helps. Do let me know if it isn't clear.

 

 

@ankitpatira

Ok, Thanks clear now!

 

"Streaming data in your dashboards and reports using Microsoft Power BI REST API or Microsoft Stream Analytics." for free edition is 10K rows/ hour

 

One question then - how can I estimate if this 10K rows / hour for my solution is sufficient?

@prokurors you will find that out by using your reports. If you notice they take long to load plus you see refresh spinning wheel more often then most likely 10k rows/hour is not enough. Just use your reports for few days and you will find out.
Greg_Deckler
Community Champion
Community Champion

I believe the key words in that document are "live data source".  If you do not connect "live" (in other words scheduled refresh and use Azure SQL, you should not need a pro license. If you do need a pro license, everyone needs to have a pro license to edit or view it.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler - I've just recently changed my desktop report to hit against an Azure SQL Database - the connection is set to 'Import' rather than 'DirectQuery', and I set-up a daily refresh in the online portal. It now tells me that the report has Pro content. From your answer here it makes it sound as it shouldn't - do you know if this has changed?

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 community update carousel

Fabric Community Update - June 2025

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