Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
2 years ago

DATA REFRESH

I have a huge data set of containing rows 1cores and I'm using direct query to load data on the report but when i refresh the datasets it's taking apporx. 10 min. to get refreshed and loading of data.

Is there any way to optimize or somthing to reduce the loading time ??

 

Thanks & Regards,,

Need Help

2 Replies

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    Hello! Is your model set up with fact and dimension tables? Direct Query report rendering will always be slower than reports in import mode. Are you saying your visuals take 10 minutes to render? 

    • BIswajit_Das's avatar
      BIswajit_Das
      Impactful Individual
      2 years ago

      Hello audreygerred  Thanks for responding
      No not the visuals but the used data queries takes a large amount of time to load data on the report data model.