number of rows that power BI can process

[chandramouli]

Hi All,

Can anyone give information on the number of rows that Power BI can process..

Thanks,

Arun

[v-ljerr-msft · Accepted solution]

Hi @chandramouli,

There is no limitation on the rows of data you can import into Power BI currently. However, Power BI offers two licenses, Power BI (free) and Power BI Pro, with different data capacity limits:

• Free users have a maximum 1 GB data capacity.
• Pro users of Power BI Pro have 10 GB maximum capacity.
• Pro users can create groups, with a maximum 10 GB data capacity each.

References:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-manage-your-data-storage-in-power-bi...

https://community.powerbi.com/t5/Desktop/Number-of-records-limitation/td-p/9552

https://community.powerbi.com/t5/Desktop/Power-BI-10-000-rows-limit-Question/td-p/17715

Regards

[chandramouli]

Hi Jerry Li,

Appreciate your response!..Can you let me know how much does it cost to get a Power BI pro license.... Waht are the additional advantages involved in getting a Power BI pro license versus having a Power BI desktop free version...

Thanks,

Arun

[Anonymous]

Hi 

it's not just a matter of rows (many before me answered that there is not a limitation in number of rows): it's also a matter of cardinality (number of unique values) and colums.

1M rows with 100 columns and all of them with unique values is a demanding dataset for PowerBI.

100M rows with 2 columns and a couple of different values (low cardinality) will be very easy.

That's because the way VertiPaq works: it's a compressed columnar db.

[KHorseman]

https://powerbi.microsoft.com/en-us/pricing/