Forum Discussion
DATA SET SIZE
Hi all I have the followin problem: "The size of one table is anormally huge" Context: DB: redshift 1 Table 25 M records +12 Columns 800 Mb size The problem is that one field (ID_KEY) ...
Hi Anonymous
When importing data into Power BI, it would compress data using VertiPaq Engine.
Do you use the VertiPaq Analyzer to check the dataset size?
https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/
If so, please go to Edit queries, "Transform->Format->clean/trim" for this column.
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds really good but I can´t isntall any additional program in my PC.
I would try to do it in other ways