Forum Discussion
Solved
Multiple relationships between tables?
Hello all, Brand new to Power Bi and having trouble figuring something out. I have a product table that contains Product IDs. I also have an order table with orders, some of which contain ...
In Power Query, go to the Order table and split the column with multiple Product IDs into rows (one row per Product ID). Then create the relationship between the tables using Product ID.
The line item fields are in json and look like the following. This example order has 2 product ids.
Its quite long when copied here so I made a pastebin link:
"line_items": [ { "id": 14419813204035, - Pastebin.com
Thanks for the example. You could try Transform --> Parse --> JSON for that column, and then split into rows.