Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Can anyone give information on the number of rows that Power BI can process..
Thanks,
Arun
Solved! Go to 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:
References:
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
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:
References:
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
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
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.
https://powerbi.microsoft.com/en-us/pricing/
Proud to be a Super User!