Forum Discussion

burcubelen's avatar
burcubelen
Frequent Visitor
4 years ago

How to keep history data and never refresh

Hi, I have a log dataset that history data never changed. It has 6+ million data. Incremental refresh is broken because of the amount of data. It was starting to give 'insufficient memory' error...
Need Help
Show and Tell
Tips and Tricks
v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi burcubelen ,

 

You can choose import mode. As long as you don't run manual refresh or schedule refresh, refreshing the report won't trigger a refresh of the dataset.

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

burcubelen's avatar
burcubelen
Frequent Visitor
3 years ago

Hi v-yadongf-msft,

 

Thank you for your respond.

 

SearchData-2022-1 and SeachData-2022-2 tables all in same columns and data types. The difference is only the time interval. I split data because of the amount of data. If I get them seperately like I said, eventually I need to append them to use in only one source. And if I select refresh only appended source, it is again refresh it from scratch. I think I can't merge all the same tables.If I use the Id column to merge, there is no common Id value in both. I hope I can explain the problem clearly.

 

If you have any other idea, I would happy to talk about it. I'm still searching.

 

Thanks