Hi @CStaich,
Alternatively you could:
- load all the legacy tables into a Workspace Dataflow,
- load all accompanying dimension mapping tables into the same Workspace Dataflow.
- Perform the replacement of the legacy ID’s by the new ID’s in this Dataflow.
- Shape all output tables so they match your new ERP column headers
- Dataflow refresh only has to be performed once and doesn’t have to be scheduled because this data will now never change.
- Decide if Dataflows could be perferred over querying directly against the new ERP system.
- (If so, create a new Dataflow for all Queries against the new ERP system and schedule refresh)
- In Power BI you’ll query the legacy system Dataflow fact tables
- and query the new ERP system fact- and dimension tables (directly or via a dataflow)
- You can append all fact queries because the column headers match
.
I hope this is helpful.