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
madzgalj_darko's avatar
madzgalj_darko
Frequent Visitor
3 years ago

Thanks everyone, 
but i'm still kinda stuck. 


 So this is my data. "Tiketi arhiva " (2) is archive from 01-Jan 2023 until 01-June  2023

And "Tiketi" (1) is postgresql Import from 1-June 2023 until today. Then I append 2 in 1. 
What should my RangeStart and RangeEnd be? What dates?
On which i should put incremental refresh after that? On both or only one? I put on both and now my refresh time is 2x slower then without incremental.

 

 

 

 

 

 

 

 

 

 

And one last thing. My incremental setup looks like this. Is it alright? Or I should set it up different? This is causing me a lot of problems. Becouse without incremental i have a timeout in refresh on few datasets. And would really love to solve this with your help. 
Thank you guys !

 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Does the Power Query for your "Tiketi"  table have a RangeStart/RangeEnd filter?  Which field is that filter based on?

     

    Can you show the Power Query code?

    • madzgalj_darko1's avatar
      madzgalj_darko1
      Regular Visitor
      3 years ago

      That's what I'm asking, should my filters and incremental refresh be on "Tiketi" or "Tiketi arhiva"? And what dates should I put in incremental refresh? Based on the data I said are stored in tables? 

      Thank you