Forum Discussion

aume1's avatar
aume1
Helper I
5 years ago
Solved

Incremental Refresh not working when data is updated

Hi,    I've recently created a test report to see if Incremental Refresh works with PBI Pro connected to MS Blob Storage. The data is imported as .parquet file. There are two reports (exactly the s...
Need Help
  • aume1's avatar
    aume1
    5 years ago

    Hi v-xulin-mstf , 

     

    I've managed to fix the problem by extending the refresh period from 3 days to 2 months, store period to 3 months! I'll mark this thread as solved. Thanks for the guidance!

aume1's avatar
aume1
Helper I
5 years ago

Hi v-xulin-mstf , Thanks for the reply!

 

I've changed the data source to Azure SQL DB with the same setting, but to no avail (Even though View Native Query option is active).

I've also been trying to connect DAX Studio to Power BI Service dataset to verify the incremental refresh but keep on encountering an error saying: 

with the powerbi://api.powerbi.com/v1.0/myorg/MYWORKSPACENAME 

 

Is there any other methods to check how/why incremental refresh is not working?

  • aume1's avatar
    aume1
    Helper I
    5 years ago

    Another thing to mention is that when Incremental Refresh is not applied, the data refreshes fine on both Desktop and Power BI service, whereas applying only works on Desktop 

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi aume1,

     

    In your case, maybe the following cause your issue.

    You can alao refer this to do troubleshooting.

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

    • aume1's avatar
      aume1
      Helper I
      5 years ago

      Hi v-xulin-mstf , 

       

      I've managed to fix the problem by extending the refresh period from 3 days to 2 months, store period to 3 months! I'll mark this thread as solved. Thanks for the guidance!