102 votes10 comments · Power BI Ideas » Gateways (Enterprise and Personal) · Flag idea as inappropriate… · Admin →Mark commented
This is a MUST for our org to use Power BI at an enterprise level. Power BI Admin console does not provide enough audit and controls for admins.
We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.
At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.
You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh
We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!Mark commented
I understand there a a few complications to this. One thing that comes to mind is a true incremental that just appends data should hopefully be a fairly straight foward solution in Power BI Cloud, however if you require a insert\update option based on a PK I imagine it becomes a little more complicated. Either way this feature is seriously needed. MS, this request is about 2 years old. It would be great to have an update if there are plans for this feature and if so some idea of timelines and basic features.