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...
Need Help
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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi,

        obsviously, I tried this, and I tried with a new file too and the result is the same on Power Bi Service.

        This is my incremental configuration.