cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sanchit Frequent Visitor
Frequent Visitor

Power Bi Desktop10 million row Limitation

 

Hi

I need some clarity about the PowerBI row limitation. I had watched one video that row limitation is 10 million rows.  I was not able to figure out if limitation is for Data refresh or total no. of rows that Power Bi can analyze or no. of rows in one table that is imported to power BI.

And if I have connected to some Database like MySql , Oracle then also there would be any limitation on no. of rows?

 

Thanks in advance.

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

Re: Power Bi Desktop10 million row Limitation

@sanchit

If you've got Pro account it takes an hour to load 1M rows in power bi service.
For free account total size of all datasets can be maximum 1GB. For Pro it is 10GB.
Each dataset cannot be more than 1GB for both free and Pro account.

Hope that helps.
Super User
Super User

Re: Power Bi Desktop10 million row Limitation

@sanchit - You can get around the row limitation by using direct access methods. The limitation is for import.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: Power Bi Desktop10 million row Limitation

Hi @sanchit,

 

Based on my research, if we use Import mode to refresh the data, all data set in the report will be refreshed again. If the dataset has large amount of data, the performance will be poor.

 

Besides, the table or matrix visual can display whole dataset value and it will generate scroll bar for us to view all data automatically. But in other visuals, like line chart and column chart, it will prompt us that it's not able to display all data as there are too many values, and we need to filter data then display it.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sanasamadsisc Frequent Visitor
Frequent Visitor

Re: Power Bi Desktop10 million row Limitation

Hi,

 I  have more then 10 million of record to display in power bi report.  the dataset exceeds the 1 gb size and is not supported  both in import and direct query mode.

Do you have any solution to dispaly more than 10 million rows in rpert ?

 

Thanks in advance

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 343 members 3,045 guests
Please welcome our newest community members: