Forum Discussion
Vertipack analyzer and debugging
Hi, UlisesCiccola
If you have a needed column which is the heavier in your model,the best option is to remove the column and retrieve the same data in other ways. For example, create a composite model keeping that data in a separate table, or create other reports to retrieve that information.
Please check if these related videos are helpful to you :
Reading VertiPaq Analyzer metrics in DAX Studio
2 ways to reduce your Power BI dataset size and speed up refresh
Best Regards,
Community Support Team _ Eason
UlisesCiccola I assume ID is a primary key/unique value. Do you need it in the model?
parry2k yes, very much needed! Cannot eliminate that column. Would an integer column perform better? But I would have to merge the new column with another table and that could make queries update slower.