Forum Discussion
queries and merging
- Jul 07, 2020
You don't need to merge queries. Load tables to data model and follow the instruction literally, starting with Section 2 (create relationships).
You don't need to merge queries. Load tables to data model and follow the instruction literally, starting with Section 2 (create relationships).
- gltechJul 07, 2020Copper Contributor
SergeiBaklan nevermind! I got it! thank you for your help!
- gltechJul 07, 2020Copper Contributor
SergeiBaklan Ok, I understand that part, but how do I load the two separate tables into a data model? I know how to load one, but in order to load both do I need to paste both data tables onto the same sheet and use that?
- SergeiBaklanJul 07, 2020Diamond Contributor
If you Power Query the data, no need to load table into worksheet. You shall have two queries for two tables. In queries pane right click on query name, select Load To and choose correct option.