Investigating RAM consuming DAX

[AGo]

Hello,

I've got my 20MB report uploaded to the service since 2 years, now is failing to refresh because one or more of my DAX measures is too RAM consuming. I think is not a problem of row quantity that has increased because the problem continues if I limit the query to the last 6 months, maybe microsoft lowered the available memory or maybe the data types that are arriving have higher memory consumption effect.

My question is: trying to delete step-by-step every measure and refreshing data looking at the RAM consumption in task manager is the only way to try to discover which DAX has this problem or there is a more clever way? I don't have details in my refresh error on the service and in desktop I can only find tools that tell me how much data are stored after refresh but not peak RAM consumption during refresh.

Thanks a lot for attention!

[amitchandak]

@AGo , Refresh failing of measure is strange. You should download pbix and analyze measures using a performance analyzer and Dax studio

If you are a premium customer, you can use XLMA endpoint and SSMS to refresh each table and check

Power BI Premium - XMLA Endpoint - Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI

[AGo]

This specific report is not currently in a Premium capacity, but I can move it in a Premium capacity for this debug reason if needed. I've got only one table in this report.

So you confirm that PowerBI has strict limits on RAM consumption in service for PRO users but doesn't provide the information of which DAX or M function made the refresh fail in the service or useful infos about this in the Desktop? Thanks