You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?
Tuki93
Highly Voted 3 months, 3 weeks agoAdriel_1996
1 week agoGHill1982
3 months, 1 week agoh2o_molecule
1 month, 3 weeks agodazero
1 month agoRaibeth
1 month, 3 weeks agoIshtarSQL
Highly Voted 3 months, 3 weeks agokumarzzz
Most Recent 3 days, 2 hours agoMultiCloudIronMan
3 weeks, 5 days agozxc01
5 days, 2 hours agoSher_Lock_Alexa
1 month agohebertorosillo
1 month agodazero
1 month agoChenFu
1 month, 1 week agohenryphchan
1 month, 2 weeks agoclux
1 month, 3 weeks agoprabhjot
1 month, 3 weeks agoh2o_molecule
1 month, 3 weeks agorobertlavigne
2 months, 1 week agoi_have_a_name
2 months, 2 weeks agomixonfreddy
3 months agomanolet
3 months, 1 week agoQAZdbarhate12345678
3 months, 2 weeks ago