Forum Discussion
Data size limitation for pivoting data
Hi there.
I am wondering if there is a limitation in data volume (lines of data) when trying to pivot.
Thanks,
Hi hmwpbi_24 ,
It's not just a matter of rows (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.
The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
hmwpbi_24 , each visual has limit, refer
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
V-lianl-msftCommunity Support
Hi hmwpbi_24 ,
It's not just a matter of rows (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.
The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
