Forum Discussion
Please someone clarify this question
None of the above. Run OPTIMIZE to consolidate the files into the desired 1GB chunks, and consider using yearly partitions.
(they want you to increase the capacity, of course)
Hi Sinduja,
Thank you for reaching out to Microsoft Fabric Community.
Given the data growth and the performance issues you're seeing in Power BI Direct Lake reports, the best approach would be to enable V-Order. This optimizes columnar storage, improving query performance significantly without increasing costs.
Adding to what lbendlin said, running OPTIMIZE in your Fabric Warehouse will consolidate small Delta files into efficient 1GB chunks, reducing the overhead on queries. Since your reports rely on year-over-year analysis, implementing yearly partitions can further improve performance by limiting the amount of scanned data.
Scaling up capacity F32 to higher is always an option, but before increasing costs, I would recommend enabling V-Order and optimizing storage. Let us if you any further queries.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Advocate IOk, Optimize would make sense...but to choose from the available options A-E:
is it:
B) Increase the capacity (only F64 can handle 500 million rows...). But: "Minimize operational costs."
C: Enable V-Order. Well, it's switched on by default - but since WHEN? (I.e., is it a possible "miss" during re-designing the exam?)
I think [B) Increase the capacity] is the answer. It will increase the Licensing Cost and still aiming to "Minimize operational costs" 😊