Forum Discussion
Power Query: Merging on virtual table from starting CSV takes too long and repeats code execution
Do you have to do the merge in Power Query or could the data model do the work for you?
There are some really good articles on Table.NestedJoin and its pitfalls.
lbendlin I would prefer it happen in Power Query itself. When you say Data Model, do you mean in the primary data source location? I do not have access to that, only the denormalised CSV output.
No, I mean the Power BI part, after you loaded the queries you can join the tables in the data model view
Not sure how I'd use Join in the Data Model though. I am basically normalising the flattened CSV output. So taking a distinct of some table columns in a separate table, generating Ids, replacing those columns in the flattened table with the generated Id.
I assume the Join needs to be done in Power Query itself, in this scenario.
