Maximum Memory we can update under Data cache management Options.

[Heena_9980400]

Hi Experts,

For the above image attached, by default the data cache Management memory is 4096 and my concern is what is the maximum number we can give, is it fine if I give 16000? Looking forward for your reply.

Thanks,

Hina

[Samarth_18]

Hi @Heena_9980400 ,

Could you please let us know the reason for extending it?

Since this option is only for the caches the data when you are using PBI in the Query Editor.

Basically it caches the data generally first 100 rows so that it does not have to load all the data when user still in the Query Editor.

Thanks,

Samarth

[Heena_9980400]

Hi @Samarth_18 
I am getting an error which is shown below

[Samarth_18]

@Heena_9980400 , When this error getting occur,on executing any measure or while loading data?

[Heena_9980400]

Hi @Samarth_18 
after loading data when I tried to drag columns(it's occuring if I'm trying to put more than 7 to 10 columns) on table visual and there are no measures or anything used here.
I think due to more data its happening or something i don't know

[Samarth_18 · Accepted solution]

@Heena_9980400 Several steps you could follow to reduce data in the report.

1. Try to remove the column which is not required in the report.
2. Try to add the required filter before load.
3. Please check the relationship if there is any many to many relationship.
4. Convert custom column to measures (if possible)