Skip to main content

Power BI

Needs Votes

Incremental Refresh in Dataflow for Power BI Pro users

Vote (455) Share
Ruben Sequeira's profile image

Ruben Sequeira on 20 Feb 2020 16:53:40

Also include incremental refresh in dataflow for Power BI Pro users.

Comments (14)
Ruben Sequeira's profile image Profile Picture

e18c072a 66cf-ea11-a812-000d3a579c34 on 26 Jul 2020 17:40:05

RE: Incremental Refresh in Dataflow for Power BI Pro users

I thought this was already available, but it isnĀ“t, and I find it beneficial both for MS and for the end user.

Ruben Sequeira's profile image Profile Picture

cdc16e85 ce69-4b92-a215-93bc14418b11 on 06 Jul 2020 00:15:37

RE: Incremental Refresh in Dataflow for Power BI Pro users

But incremental refresh not enabled for pro users for dataflow ! Please enable for pro

Ruben Sequeira's profile image Profile Picture

ff5cc1c2 472b-4be5-bb01-838a063eeda1 on 06 Jul 2020 00:13:36

RE: Incremental Refresh in Dataflow for Power BI Pro users

Seriously, how can such a fundamental piece of Power BI / Powery Query functionality not be provided with a Pro licence?

We spend months/years honing best practices in Power Query, teach our clients how to create good models, and then you can't do it in Dataflows without a significant outlay on budget?

Please consider a change on this one. Too core to the Desktop client to not allow it in the PBI service for Pro customers.

Ruben Sequeira's profile image Profile Picture

7ef828a7 91fa-43f5-86a9-1c4ce2836d53 on 06 Jul 2020 00:11:34

RE: Incremental Refresh in Dataflow for Power BI Pro users

Please include incremental refresh on dataflows for Pro Licences.
It would be a huge benifit.

Ruben Sequeira's profile image Profile Picture

99da7895 2581-e911-a98e-000d3a4f3343 on 06 Jul 2020 00:11:24

RE: Incremental Refresh in Dataflow for Power BI Pro users

Very much so. Especially when your datasource does not allow for query folding, incremental refresh would still speed up the report refresh through a dataflow.
Currently, it's not of much use to me, since the vast majority of my datasources do not allow for query folding, and in general most of my reports are built on dataflows to begin with.

Ruben Sequeira's profile image Profile Picture

e76f8814 61d0-416b-9563-d55ce424610e on 06 Jul 2020 00:08:58

RE: Incremental Refresh in Dataflow for Power BI Pro users

I was very excited to see Pro users getting incremental refresh - until I realised it was Datasets only! There is more of a requirement to have this in Dataflows I think.

Ruben Sequeira's profile image Profile Picture

fab9e5fa 2e39-4d31-8852-f6b9e5079ce9 on 06 Jul 2020 00:04:58

RE: Incremental Refresh in Dataflow for Power BI Pro users

Even having a limited amount of computed entity refresh would be helpful. Moving more common calculated elements out of datasets and into dataflows will improve reusability and help medium to small businesses make much more effective use out of Power BI.

Ruben Sequeira's profile image Profile Picture

d5595f1f 011e-403f-9b16-6c070d93fcf3 on 05 Jul 2020 23:58:41

RE: Incremental Refresh in Dataflow for Power BI Pro users

CSV files consume a lot of space. Ideally, the storage should be in parquet or AVRO format.

Ruben Sequeira's profile image Profile Picture

d5595f1f 011e-403f-9b16-6c070d93fcf3 on 05 Jul 2020 23:58:41

RE: Incremental Refresh in Dataflow for Power BI Pro users

A single dataflow with a single entity with few fields consumed about 3GB. In addition to taking up a lot of disk space, the Entity's load time is absurdly high. We need to optimize this so that the use of dataflow is warranted (especially if we rely on it with self-service).

Ruben Sequeira's profile image Profile Picture

87fd6b64 efca-4dc8-8c2f-de05e2f7ed75 on 05 Jul 2020 23:51:36

RE: Incremental Refresh in Dataflow for Power BI Pro users

Can we have an update please. I will say I was joyed about dataflows till I realised of all the limitations microsoft put on small business.