Forum Discussion

Minakshi's avatar
Minakshi
Resolver I
5 years ago
Solved

incremental refresh setting power BI desktop

Hello Experts, I have configured my data set for incremental refresh as the following manner. I have 2 main tables and 2-3 refrenced tables. Main tables having date time with refrenced tables havi...
Need Help
Show and Tell
Tips and Tricks
  • Minakshi's avatar
    Minakshi
    5 years ago

    Anonymous  Thank you so much. I found the issue. Issue is related to query folding. When I change type of any column query folding doesn't apply and due to this incremental refresh is not working. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Minakshi,

>>Data is coming correct with March and April. For remaining  months cards go blank.

I'm not so clear about your description, can you please explain more about these? Did you mean the refresh not affect some of the report contents?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Minakshi's avatar
Minakshi
Resolver I
5 years ago

Anonymous  Thank you so much. I found the issue. Issue is related to query folding. When I change type of any column query folding doesn't apply and due to this incremental refresh is not working. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Minakshi,

    I'm glad to hear you find the root causing and share it here.‌‌🙂
    I think they will help others who faced the same scenario.

    Regards,

    Xiaoxin Sheng