Forum Discussion

aume1's avatar
aume1
Helper I
5 years ago
Solved

Incremental Refresh does not load newly loaded data

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

    I've solved the issue by extending both storage period and refresh period to 3 and 2 months respectively. I'll mark this thread as solved and thanks for the guidance!

lbendlin's avatar
lbendlin
Super User
5 years ago

1, yes, you need to do that. Keep in mind that Incremental refresh only works on the SECOND refresh after a meta data update.

2. It's just a note, not a warning.  Query folding is not required for incremental refresh to work.

 

The ONLY true way to check that incremental refresh is working is to connect to the dataset in the Power BI service (for example via DAX Studio or SSMS) and to validate the refresh timestamps on the partitions.  If you only see one partition then you know it's not working at all.

  • aume1's avatar
    aume1
    Helper I
    5 years ago

    Thank you for replying! 

     

    Could I ask you what the required steps are to verify the incremental refresh using DAX Studio? I've been trying to connect DAX Studio to PBI Service dataset through powerbi://api.powerbi.com/v1.0/myorg/Word1%20Word2%20Word3%20Word4 (instead of Word1%...Word4, I used my workspace name), but keep getting an error:

    Is it because I'm not on Premium Capacity?