Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
max_mrc
Frequent Visitor

Power BI Desktop Latency after 18/03/2025 Update

Power BI desktop is taking long time to create new column using lookup function, measure creation etc after the 18/03/2025 update. Data source is Excel file from sharepoint. Thanks

1 ACCEPTED SOLUTION
grazitti_sapna
Super User
Super User

Hi @max_mrc , 

Possible reasons for the same can be: 

  1. Update Bugs: New updates sometimes introduce bugs or performance issues.
  2. Cache Issues: Power BI Desktop caching might not be functioning optimally.
  3. DAX Performance Issues: Complex DAX formulas or heavy use of LOOKUP can slow things down.

You can try using some troubleshooting steps: 

  • Check Performance Analyzer:

    • Go to View > Performance Analyzer and start recording while performing the slow operations.
    • Check for long-running DAX queries or visuals.
  • Simplify DAX Formulas:

    • Avoid heavy LOOKUPVALUE functions or iterators.
    • Consider using MERGE operations in Power Query instead of LOOKUPVALUE.
  • Clear Cache:

    • Go to File > Options and settings > Data Load > Clear Cache.
    • Restart Power BI Desktop.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

 

 

 

View solution in original post

1 REPLY 1
grazitti_sapna
Super User
Super User

Hi @max_mrc , 

Possible reasons for the same can be: 

  1. Update Bugs: New updates sometimes introduce bugs or performance issues.
  2. Cache Issues: Power BI Desktop caching might not be functioning optimally.
  3. DAX Performance Issues: Complex DAX formulas or heavy use of LOOKUP can slow things down.

You can try using some troubleshooting steps: 

  • Check Performance Analyzer:

    • Go to View > Performance Analyzer and start recording while performing the slow operations.
    • Check for long-running DAX queries or visuals.
  • Simplify DAX Formulas:

    • Avoid heavy LOOKUPVALUE functions or iterators.
    • Consider using MERGE operations in Power Query instead of LOOKUPVALUE.
  • Clear Cache:

    • Go to File > Options and settings > Data Load > Clear Cache.
    • Restart Power BI Desktop.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

 

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.