Forum Discussion
Super UserDax 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
Super Userthank you. I can not share unfortunately data model...
Super UserOK then what you can do is (in another post so we keep thing clean):
include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Please include the DAX code of the measures that you will put in the visual you recreate so we can optimize
Need help uploading data? click here
Want faster answers? click here