Forum Discussion
Error Message
Hi Malps90,
What version of power bi are you test? 32bit or 64bit? AFAIK, 32bit applications have limitations on memory resource usage. I'd like to suggest you switch to 64bit If you are work with 32 versions, it allows you to use more memory resources to calculate.
how much memory can be accessed by a 32 bit machine?
In addition, you can also open task manager to track how much idle memory available. It may also cause the issue if your device does not have enough idle memory resources.BTW, what type of operations you proceed in query editor? Any complex reference/invoke/looping calculation in your query tables? If this is a case, you can consider using buffer functions(List.Buffer, Table.Buffer) to avoid the memory leak of iterate calculations.
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
Hi,
The particular table i am applying ot query too i need all columns and there is only aproximately 10 columns however there is alot of tables in the report and i might be able to reduce this down.
some of the tables have alot of data in them which have alot of caluclated columns in.
i have been looking at a way to reduce the coding but not sure if that would help.
Many Thanks
Hi Malps90
reduce the model to the required data.
Calculated columns (DAX) are not saved as efficiently as columns calculated in Power Query.Maybe you can optimize here.
Thank you
From your experience if i filtered the data out in the query would this help to reduce the intake of the data? or would i need to rediect where its pulling the data from and reduce it there.
alot of out stuff is pulled from sharepoint due to not having a direct link into our systsems.
Thanks