Forum Discussion

shubhamdlemon's avatar
shubhamdlemon
Regular Visitor
7 years ago

Large dataset issue

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

Need Help

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    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's avatar
      shubhamdlemon
      Regular Visitor
      7 years ago

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