Solved: Analyze memory usage for query execution

AlinaDelphia · ‎09-11-2024

Hi dear community,

I faced an issue that the query uses more memory than configured limit.

I did some optimization and it works now. However, I don't know how much the optimization helps (what is the new memory consumption?). What if tomorrow I will hit the limit again?..

I'm looking for a tool to measure performance, including memory usage, and would appreciate a lot all the tips you may suggest.

Thanks!

rahmarx · ‎09-11-2024

Hi Alina, the tool I use to measure DAX performance is Dax Studio. There, you can connect to your model in Power BI Service (to get the real memory comsumption information) and run the visual query you get from the performance analyzer in Power BI Desktop. You can make some updates to the DAX in Dax Studio and run there the query with the updated DAX to know how much memory the improved Dax will use until you have the results you need. It's possible to check the memory limit in the Power BI Administration settings.

View solution in original post

rahmarx · ‎09-11-2024

Hi Alina, the tool I use to measure DAX performance is Dax Studio. There, you can connect to your model in Power BI Service (to get the real memory comsumption information) and run the visual query you get from the performance analyzer in Power BI Desktop. You can make some updates to the DAX in Dax Studio and run there the query with the updated DAX to know how much memory the improved Dax will use until you have the results you need. It's possible to check the memory limit in the Power BI Administration settings.