Large dataset issue

[shubhamdlemon]

Hi All,

I have a relatively large dataset with more than 10M rows. When I try to refresh it I get an error that the visuals cant be loaded at this time, Please check my more resources are available.  My desktop ram is 16GB and I am assuming my dataset will grow untill 35-40M rows. I have a weekly refresh on the data and theres no way I can aggregate it due to the requirements. Can someone help. I have to refresh the complete dataset as the data loaded earlier keeps on changing. I have attached the

errorsnippet of the error

[jdbuchanan71]

Hello @shubhamdlemon 

If you make a new page in your .pbix with a simple view like total amount by month, does that load?  If so, are you able to refresh the data while viewing that page?  It may be that the measure that is calculating in your visual is the problem rather than the raw size of the dataset.

[shubhamdlemon]

Thanks for the reply. It is happening with all the measures. When I reduced the datset to 2M it works.