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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.