Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualmany to many
i am working on building semantic model where i encountered many to many between case and product table as shown below, this is valid relationship between case and product tables, source for power bi is snowflake, i do not want to create bridge table in power bi , is there a way to handle this in snowflake?
Handling many-to-many relationships directly in Snowflake without creating a bridge table in Power BI is indeed possible.
- Even though you don't want to create a bridge table in Power BI, you can still create it in Snowflake. This table will store the relationships between your CASE and PRODUCT tables.
CREATE TABLE CASE_PRODUCT (
CASE_ID NUMBER REFERENCES CASE(CASE_ID),
PRODUCT_ID NUMBER REFERENCES PRODUCT(PRODUCT_ID)
); - When querying the data in Power BI, you can join the CASE and PRODUCT tables using the bridge table.
- Even though you don't want to create a bridge table in Power BI, you can still create it in Snowflake. This table will store the relationships between your CASE and PRODUCT tables.
1 Reply
- Kedar_Pande
Super User
Handling many-to-many relationships directly in Snowflake without creating a bridge table in Power BI is indeed possible.
- Even though you don't want to create a bridge table in Power BI, you can still create it in Snowflake. This table will store the relationships between your CASE and PRODUCT tables.
CREATE TABLE CASE_PRODUCT (
CASE_ID NUMBER REFERENCES CASE(CASE_ID),
PRODUCT_ID NUMBER REFERENCES PRODUCT(PRODUCT_ID)
); - When querying the data in Power BI, you can join the CASE and PRODUCT tables using the bridge table.
- Even though you don't want to create a bridge table in Power BI, you can still create it in Snowflake. This table will store the relationships between your CASE and PRODUCT tables.