incremental refresh for Power BI Pro

[Topher606571]

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

[deepak_agrawal1]

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

[maxui]

Absolute must have feature

[bj_de_bakker]

PLEASE!!! Fixit

[simon_nuss1]

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

[info83]

Also, we need the ability to do incremental loads from Analysis Services.

[feldi68]

Stronlgy support this feature. In the meantime you can use this workaround: http://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/

[imkhan222]

i need to refresh the whole data set everytime i refresh please get this feature

[moneer_jlelaty]

A must have feature, we are loading a lot of data which will be loaded again every time. If we can only load the newest data, that will save a lot of time, please start working on it.

[Anonymous]

'PBI offers a breadth and depth of data connections (including many Azure platform services) which, is awesome. Most BI tools offer connection parity, but the big differentiator is the amount of custom configuration that can be set to optimize how data is loaded including whether a bulk load or incremental load is fetched during a refresh. Azure services like HD Insights or Azure SQL DW are positioned with PBI to work in concert with each other against the most complex and large data volumes. Yet, PBI doesnt offer an incremental load setting? IMHO, that poses a conundrum. I have a 1 tab PBI dashboard comprised of 6 charts + 2 tables. This connects to an Azure SQL DW level DWU 300 in which we have loaded a 2.5 GB slice of representative data (it's a poc). A full refresh takes 6 minutes to complete. Within the dataset, we have 10 tables: 1 fact-like table, 8 dim tables and 1 lookup table. It's about as perfect a starflake as you can get. So, my poc test scenario is not uniquely voluminous nor complex. The full dataset once loaded will be 1 TB. Dashboard refresh schedule is 1 x per 24 hour day. Part of planning for a SQL DW includes analyzing query plans, DWU usage, et al in order to estimate performance vs. consumption cost, especially important when you are paying by the minute/hour. So, here is my "back of napkin" math breakdown to elucidate WHY incremental refresh is absolutely necessary to truly drive PBI & Azure adoption of big data/adv analytic workloads (based off the current Azure Cost Calculator estimates): - 2.5 GB takes 6 minutes to refresh or 2.4 min per GB - Refresh schedule limited to 1 x per day (every 24 hours) - 1 TB refresh would take roughly 2393 minutes or 39.88 hours - Azure Cost Calculator estimates East2 region hourly cost = $3.63 + storage cost (not inc) Therefore... - $3.63 x 39.88 hrs = $144.76 per da *FULL* refresh / $4,343 per month - Here's the kicker: a full refresh incurs same cost whether data changed or not!!! Now, t

[llew_ird]

Any update on this feature guys? Its been under review for a long time! We need this feature!!!!