Forum Discussion

Minakshi's avatar
Minakshi
Icon for Resolver I rankResolver 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 having month column. I want to refresh data for last 9 months and after that I want to refresh only daily data. 
1. Do I need 2 seprate coulumns for (Rangestart, RangeEnd) and maximum datetime column in incremental refresh setup?

On service, I am getting useless data. Cards are showing infinity, trends are getting doubled for some dates.

Thanks in advance

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. 

6 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Minakshi ,

     

    no, you filter the same column with the desired range.

    Be sure that you set the filter of the data column properly ("is after or equal" and "if before"):

     

    Then the refresh should work.

     

    Also check the documentation, it's pretty well described:

    Incremental refresh in Power BI - Power BI | Microsoft Docs

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Minakshi's avatar
      Minakshi
      Icon for Resolver I rankResolver I
      5 years ago

      selimovd I want data to be refreshed for last 9 months. In my RangeStart (3/1/2021) and RangeEnd(5/1/2021) . Data is coming correct with March and April. For remaining  months cards go blank.
      can you help me with this.

      • 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
    Icon for Resolver I rankResolver I
    5 years ago

    Does incremental refresh works with mysql database import mode ? As I don't get view native query option with this.