The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello. I want to use performance analyzer to see how long does it take to load the DAX and visuals. But I wonder if I run it multiple times, will the subsequent runs be affected by the cache built in the previous runs? If it does, I think this will make the performance analysis not accurate.
This is a good question that I would like an official answer to.
In the meantime, there is a "Clear Cache" external tool you can install and run before refreshing the visuals.
@Anonymous,
You can use DAX studio, there you have the option to clear the cache
Hi @amitchandak. Thanks for the reply.
Yes, I am using DAX Studio also, but I see some difference in the DAX timing compared to Performance Analyzer. I think it is impacted by other slicers available in the page, which I want to consider when analyzing the performance.
Therefore I need to know if Performance Analyzer specifically clear the cache on each run or not.