Split source into two different queries

[samerhajjar]

Hello,

I have a Python code put into a Power Query and it returns the following two tables

What I'm trying to do is have this same query take the data from the first table and the move the data of the second table into another query.
The reason why I couldn't split this into two different queries is because the code generates a report online, and the report can't be generated twice simultaneously so I had the get the returned csv file and put it into two tables.

And also, the reason why I want duplicate tables, is because I need to have a triangular relationship in the data model and that can't work.

Any help would be appreciated.

Thank you.

[amitchandak]

@samerhajjar , Leave this table as is, create tables using reference. Now what tables you create will refer to this tbale and you will able to create triangular tables

Do not add steps to the table you have, all new table will take the final table