Forum Discussion
Incremental Refresh With Data Flow And Power BI Per User
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?
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.
3 Replies
- StefanoGrimaldiResident Rockstar
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.
- v-yingjlCommunity Support
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:
- Configure incremental refresh
- Configuring incremental refresh for dataflows
- 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.- StefanoGrimaldiResident Rockstar
for dataflow it most be in a prim workspace