Forum Discussion
hjameelq
Advocate IV
Advocate IVData Preparation on Power BI Desktop
I do have a huge dataset that has aggregated data that has to be disaggreated to be able to present it on different types of charts. The issue with that I got that I need to create a table for each q...
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeThe compression engine in Power BI doesn't like wide data as much as it likes long data, so you may see some memory issues with a 500 column table. Other things such as cardinality will also have an impact.
If I understand your question, I would use a reference query to your source query and remove all unnecessary columns for each table you need to make. Then do the unpivot on those new tables.
If I understand your question, I would use a reference query to your source query and remove all unnecessary columns for each table you need to make. Then do the unpivot on those new tables.