Data size limitation for pivoting data

[hmwpbi_24]

Hi there.

I am wondering if there is a limitation in data volume (lines of data) when trying to pivot.  

Thanks,

[V-lianl-msft · Accepted solution]

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.

[amitchandak]

@hmwpbi_24 , each visual has limit, refer

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points