Retrieve data once from Dataflow into master table, then use local copy in staging tables?

[jeff_h]

Hoping for some guidance here.

I'm wanting to setup a PowerBI report that retrieves data once from a Power BI Dataflow (around 2GB in size) and load unedited into a 'master' table.

Then I want to use and transform this data across 'staging' tables (where any custom columns and calcutations are made) referencing the master table so I only have to retreive the data once from PowerBI online (i.e. download the 2GB only once into the master table).

So I created the master table to retrieve the data from the Data Flow successfully, then created two stagings table to source specific columns required from the master table.

However when I make a change to the staging tables (i.e. add new column, change parameters, etc) anbd preview or apply the changes, both the master table and all the staging tables indivudally download the entire 2GB of data each each table from the PowerBI online.

Can I make the staging tables only use the preloaded data from the master table without having to re-download everything every time?

[ChenwuZhu_Gmail]

Hi @jeff_h ,

Im not sure my method works, maybe you can try.

1 Load the master table into power query

2 Close and Apply power query editor.

3 Create the staging tables via

New staging table = 'master table'

Best regards.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.