Forum Discussion
Solved
Duplicate source load when loading queries to the model
I'm working on a BI that has several Excel files as sources, one in particular is quite heavy (about 400MB) because it lowers historical data from SAP. The problem is that we have several queries tha...
YES! Create ONE Source in Power Query, then load it into the model. Then use a DAX statement to replicate it:
MyNewTable = OneSourceTableName
You can then apply filters, etc. to this new table.
Of course, if you have different transforms to make you have to do it in Power Query
YES! Create ONE Source in Power Query, then load it into the model. Then use a DAX statement to replicate it:
MyNewTable = OneSourceTableName
You can then apply filters, etc. to this new table.
Of course, if you have different transforms to make you have to do it in Power Query