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)
- Merged Idea (1)
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!
RE: incremental refresh for Power BI Pro
PLEASE!!! Fixit
RE: incremental refresh for Power BI Pro
Absolute must have feature
RE: incremental refresh for Power BI Pro
A must have functionality specially in case of importing from Folders....
RE: incremental refresh for Power BI Pro
I'd also like there to be straight forward way of doing this please!
RE: incremental refresh for Power BI Pro
what we really need is the ability to incrementally load data into a power pivot data model
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.
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.
RE: incremental refresh for Power BI Pro
Hi Anonymous,
could you explain a little bit more on how you've done this?
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.