incremental Refresh isn't working

[Yagevendra]

Hello all,

I am trying to implement an incremental refresh on Power Bi. My data source is hive tables. Have created 2 parameters in Power Query RangeStart and RangeEnd and pass them to the data/time column.

All other settings were done on Power Bi desktop.

When I publish the report in the service and update the data, it takes a long time as expected.

To the incremental refresh is working or not have loaded the Power Bi Dataset in SSMS. I found the file with partition on each date. It seems that all settings are correct, but I still do not know why it takes so long.

While going through the settings again its displaying on the incremental setting page.
unable to confirm if the M query can be folded.

Can you please help here how can i fix this problem.

The data is huge in Hive tables so I have loaded in Power Bi using SQL query.

[amitchandak]

@Yagevendra , Make sure, Range filter is used in beginning just after the first change Type step (Make sure date are made datetime in first change type

[Yagevendra]

Hi @amitchandak, I tried to exect same as you explained but the same thing happens view native query option is still in grayed out and the same message I can see while setting the incremental update. see attach images below.

I can not apply any step in power query to implement incremental refresh? We required to change date to date/time datatype once i applied, Native query grayed out and unable to confirm if the M query can be folded is still there.

Is there any option in power query, So i can change at least data type and applied incremental refresh?