incremental refresh

[abc_777]

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

[amitchandak]

@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]

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

[abc_777]

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?