Dataflow refresh performance

[ThanhPM10]

Hello all,

I have a issue in performance of Dataflow PBI.

I use a Premium per capacity license account.

Flow of mine refresh data is:

1. Use PBI Dataflow get raw fact_table from MS SQL Server.  Raw Table have 40mil row

2. Create a reference table in PBI Dataflow to 2 agg table smaller, with difference level of groupby for fast visual

3. Load 2 agg table to PBI Desktop workbook

and problem is:

- I have refresh a dataflow in PBI Service but in PBI Desktop its almost refresh again, and not get data from storeage of dataflow

- Refresh time of more details agg table is very slow. More slower than i load raw table (1) direct from Ms SQL and not use DataFlow

- Consume too much network bandwidth for a 600MB PBI Workbook, in img is more than 4 GB !!! 

IMG1 : Flow of query

IMG2: Refresh consume

Thanks you all,

[Anonymous]

Hi @ThanhPM10 ,

I suggest you take a look at this document about understanding and optimizing dataflows refresh.

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-understand-optimize-re... .

Best Regards,

Jay

[ThanhPM10]

Thank you,

But i see this article not help anything in my case