Dataflow refresh performance

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,