Incremental Refresh With Data Flow And Power BI Per User

[JoswinPowerBi]

Can you help me 

I did a conection with data flow to SQL Server and i want to create incremental refresh  but  i have Power Bi Per User 
My cuestion is, i need Power BI Premium  for create incremental refresh?
With Power BI Per User I can not use incremental refresh, Why?

[v-yingjl]

Hi @JoswinPowerBi ,

Incremental refresh is supported for Power BI Premium, Premium per user, Power BI Pro, and Power BI Embedded datasets.

To configure incremental refresh, the data source table must have a DateTime column first, not only a date column.

Please refer:

1. Configure incremental refresh 
2. Configuring incremental refresh for dataflows 
3. Troubleshoot incremental refresh 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StefanoGrimaldi]

for dataflow it most be in a prim workspace

[StefanoGrimaldi · Accepted solution]

hey, it should work fine for PPU lincence, but the dataflow need to be in a primiun asigned workspace to use that option on it, 

here you can get some documentation on it: https://docs.microsoft.com/en-us/power-query/dataflows/incremental-refresh

if this helped give some kudos, and if solved your problem please mark as solved for others to find.