Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power bi incremental refresh

Hi , I have few questions on incremental refresh.  Basically I have mysql database and retreive data via views.    1. I have client requirement to refresh few data set (tables) in every hour. I h...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

Incremental refresh is not a preview feature now. It is now available for Power BI Pro, Premium, and shared subscribtions and datasets. 

 

For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names 'RangeStart' and 'RangeEnd'.

 

These parameters are used to filter the data imported into Power BI Desktop, and also to dynamically partition the data into ranges once published to the Power BI service. The parameter values are substituted by the service to filter for each partition. There's no need to set them in dataset settings in the service. Once published, the parameter values are overridden automatically by the Power BI service.

 

You may change the parameter to determine data which need to be loaded in Power BI Desktop. For further information, please refer to the document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.