Forum Discussion
Investigating RAM consuming DAX
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
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