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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
djnww
Impactful Individual
Impactful Individual

Power BI 10,000 rows limit (Question)

Can someone please explain exactly how the 10,000 row limit works for the FREE version ?

 

I load Excel files with over 100,000 rows of data into Power BI Desktop and then publish the models with no issues. My reports work immediately on powerbi.com and my charts look fine. They are not missing any data.

 

What am I misunderstanding ? Will this limit only affect viewers of my reports ?

 

Thanks,

Dan

1 ACCEPTED SOLUTION
fbrossard
Kudo Commander
Kudo Commander

@djnww,

The 10 000 rows/hour limit only applies when you want to refresh dataset in real time by using Azure Stream Analytics or PBI Rest API.
You do not have this limitation when using scheduled refresh. However with the freemium version you can not have more then 5 refresh a day.

View solution in original post

2 REPLIES 2
fbrossard
Kudo Commander
Kudo Commander

@djnww,

The 10 000 rows/hour limit only applies when you want to refresh dataset in real time by using Azure Stream Analytics or PBI Rest API.
You do not have this limitation when using scheduled refresh. However with the freemium version you can not have more then 5 refresh a day.

djnww
Impactful Individual
Impactful Individual

Thanks @fbrossard

 

I only refresh data manually or via onedrive (ie. clicking on 'Publish' in Power Bi Desktop), which is why I have never run into the limit before.


Thanks for your help.

 

Dan

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors