Dax Query Consumed Memory 1063 MB,exceeded

Hi jaryszek 

the query code you pasted is generated by Power BI automatically and sent to the data model to fetch the data to populate the visual itself. There is nothing bad in the query itself. The problem is the resource usage that depends on the code of the measures, which is not in the code you sent

So, we have two options

1 - you share the pbix (via some cloud service and paste here the link) and indicate which is the problmeatic visual, so we can optimize your measures

2 - you provide a samples of data of all the tables, we need to rebuid the model, you need to provide he DAX code of each measure, how colums are goruped etc

The 1st one is faster

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI