Skip to main content

Power BI

Completed

incremental refresh for Power BI Pro

Vote (13097) Share
Topher60657's profile image

Topher60657 on 09 May 2018 21:51:12

Enable Incremental Refresh for Power BI Pro users, not just Premium.

Administrator on 20 Feb 2020 07:50:33

Happy to let you know, incremental refresh is now in Pro. Enjoy :)

Comments (643)
Topher60657's profile image Profile Picture

49caf22f 2327-470c-b1e6-53b6b487fffa on 05 Jul 2020 22:23:43

RE: incremental refresh for Power BI Pro

I understand the difficult design complexities behind implementing this but doing so will allow average users to create some pretty powerful workflows!

Topher60657's profile image Profile Picture

6aff7b22 f601-4a2e-ac6a-417e453f42c0 on 05 Jul 2020 22:23:41

RE: incremental refresh for Power BI Pro

PLEASE!!! Fixit

Topher60657's profile image Profile Picture

4749c16d 5391-49b2-aece-96981a30b25a on 05 Jul 2020 22:22:43

RE: incremental refresh for Power BI Pro

Absolute must have feature

Topher60657's profile image Profile Picture

b190267d 36b9-42f9-9824-2622527034c0 on 05 Jul 2020 22:22:34

RE: incremental refresh for Power BI Pro

A must have functionality specially in case of importing from Folders....

Topher60657's profile image Profile Picture

11781d9c d89f-41e1-8144-db1ac6e6301f on 05 Jul 2020 22:21:35

RE: incremental refresh for Power BI Pro

I'd also like there to be straight forward way of doing this please!

Topher60657's profile image Profile Picture

c5c7ff50 a060-445f-ac93-32dfd35750dc on 05 Jul 2020 22:17:57

RE: incremental refresh for Power BI Pro

what we really need is the ability to incrementally load data into a power pivot data model

Topher60657's profile image Profile Picture

c70ffae1 f7cc-44c1-89b4-a875fa967f6c on 05 Jul 2020 22:16:05

RE: incremental refresh for Power BI Pro

This post http://ms-olap.blogspot.com/2015/05/incremental-data-loads-in-microsoft.html says it works in Power Query for Excel. I tried doing the use same in Power BI Desktop but it still refreshes the existing data even thought refresh has been disable for that query.

Topher60657's profile image Profile Picture

9e5983c5 f031-41c5-892a-f4e4b37ab191 on 05 Jul 2020 22:15:59

RE: incremental refresh for Power BI Pro

Basically here is the use case. We have to load a fact table with say 1 million rows and daily 50K rows get added. I would want to the refresh operation to just add those new 50K rows or maybe only those with some update stamp.

Topher60657's profile image Profile Picture

974b1a3e fc60-420f-9090-c299ba4bed6a on 05 Jul 2020 22:15:32

RE: incremental refresh for Power BI Pro

Hi Anonymous,
could you explain a little bit more on how you've done this?

Topher60657's profile image Profile Picture

98151ea6 f29d-440d-9951-cbb19c589f08 on 05 Jul 2020 22:14:58

RE: incremental refresh for Power BI Pro

I suggest to transform the checkbox "Enable refresh of this query" to a radio button with "Enable refresh..."+*"Disable Refresh..."* options, untied from the option "Enable load to report". If you check the "Disable" option you could refresh the query only manually and thus you can perform an incremental data load staging data in one or more disabled queries and combining them with which are enabled.

Merged Idea (1)