Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago

incremental refresh

hi,

 

My incremental refresh not working

 

steps i have done as follows

1) i have create Rangestart and RangeEnd

2) make my date table as date/time format

3) right click to invoice_date column from sale table and in parameter and give rangestart and rangeend as parameter condition

3) give condition is after and is before

 

4) publish report from desktop power bi to power bi service

5) right click sale table and click incremental refesh > turn on > give 10 years > 1 day . then give tick for new data when refresh

 

next day i should see number of invoice should increase but its not.

my invoice_no and invoice_date column both are in same table

 

what is my mistake please help

 

 

3 Replies

  • abc_777 , Have you scheduled refresh on Power Bi service, Option Under dataset setting. Click on three dots on the dataset line and click on setting and then try

     

    You might have give datasource details or gateway details

    • abc_777's avatar
      abc_777
      Solution Specialist

      Hi,

       

      I have gone to power bi service then on dataset click three dot then setting

       

      in settings my schedule refresh is grayed or any other option i should tick?

       

      what i should do?

    • abc_777's avatar
      abc_777
      Solution Specialist

      please help me out from this. my schedule refresh is gray.