Forum Discussion

madzgalj_darko1's avatar
madzgalj_darko1
Regular Visitor
3 years ago

Help, about setting up data.

Hello everyone, I'm pretty new at PBI, so basically what I need help for is setting up my data so i can do scheduled refresh without problem. I have a lot of rows 4-5 mil. I'm pulling some of them ...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

There is no need to use separate tables. Have a single table, and partition it according to your data volume  (20M rows per partition is a good rule of thumb).  The maximum partition range is years, the minimum is days.

madzgalj_darko1's avatar
madzgalj_darko1
Regular Visitor
3 years ago

But if i get data from 2 tables. As i do, What then? 

I should put incremental on append table? 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    There is no point in using append and incremental refresh at the same time.  By appending you are emulating the partitions that are used for incremental refresh.  Do one or the other but not both together.