Forum Discussion

AlinaDelphia's avatar
AlinaDelphia
New Member
1 year ago
Solved

Analyze memory usage for query execution

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 help...
Need Help
  • rahmarx's avatar
    rahmarx
    1 year ago

    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.

rahmarx's avatar
rahmarx
New Member
1 year ago

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.