Incremental refresh in Desktop

[setis]

Dear experts, 

I'm working with a table of around 30M rows that needs refreshing every day. 

As far as I've understood the incremental refresh only works once uploaded to the PBI online service. However, I don't have a gateway set up and I have to do the refresh in the desktop and upload the results once a day. 

Is it possible to set up a working incremental refresh in desktop that works?

Thanks in advance

[Greg_Deckler · Accepted solution]

I don't believe so, you really need to get the gateway setup if the data source is on premises. And I would definitely look into making this a dataflow perhaps. Still in the Service and would still need the gateway.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh