Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Automatic Incremental refresh issue

Hi, 

Since we switch to 2021, the automatic incremental do something really weird, when i do a manual refresh of Power Bi Desktop, everything going well and I can publish it to my Power Bi service but when I launch an incremental refresh on Service, it's working but at the end the data of january are deleted and my data stop to 30/12/2020. I've already checked my range start/end, all my incremental parameters and nothing seems to explain why this behavior for the automatic incremental refresh. 

Everything is on Sharepoint with CSV or XLS.

Thank you for your help. 

Need Help

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Anonymous 

     

    What is the range in your incremental configuration that you have set?

     

    Also can you confirm that the CSV and XLS (This should be XLSX files) have the most recent data.

    NOTE: If you have XLS files you will have an issue with it refreshing via the Power BI Service.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Gilbert, 

      Yes the files have most recent data, as said, when I do a manual refresh from power BI desktop, everything going well and I've all the data.

      I've CSV, XLS and XLSX

      The range start ist 01/01/2018
      The range end is 01/01/2022

      Thanks for helping

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Anonymous 

     

    I think you need to ensure you only have got CSV and XLSX files and not any XLS files. I know that XLS files will not refresh via the Power BI Service.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      oh really, i didn't know this.
      I checked it and all my datafiles are CSV or XLSX

      • GilbertQ's avatar
        GilbertQ
        Super User
        5 years ago

        Hi Anonymous 


        What happens when you re-upload the PBIX and then configure the dataset data source.

         

        And then refresh it twice?

        The first time creates the partitions, the second time should then only do the incremental refresh.

         

        Also how exactly have you configured your incremental refresh policy?