Excel work book file how to make the incremental refresh in power BI

[Gokul_G16]

Hi Anonymous,

I have a excel inputs like.

Same headers based 2 file

Emp 1, Emp 2

Emp 1  yesterday date updated 

Emp 2 today date updated 

Let' s here I want set the incremental refresh in desktop.for based on today date inputs need to refresh in existing yesterday input.

How to make incremental refresh in power bi desktop?

If there have any idea,go it.

Thanks

Gokul

[Thennarasu_R · Accepted solution]

You Need to Create Manage parameters in Querry editor to Incremetal refresh.

Once you set the incremental refresh in report and publish .cannot download the report in power bi service

regards,
Thennarasu R

[Gokul_G16]

@Thennarasu_R 

Yes, 

I have around 25 file Excel sources imported into power BI desktop.

So all the excel file having merged base on primary table.

When I append in Excel latest inputs.pn the time we need to reflect to refresh in which is latest data and combine existing inputs.

The main thing is Because I need to reduce the refreshing time while occurred much hrs in have excel spreadsheet database.

Thanks

Gokul