Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power-BI Desktop won't import foreign key from Snowflake database

My Snowflake database has tables defined with primary key constraints and relationships defined with foreign key constraints. When I import the tables into Power-BI, it does not import import relatio...
  • Anonymous's avatar
    Anonymous
    4 years ago

    I got the solution from Microsoft support. There is an option in the Snowflake Import dialog for "Include Relationship Columns". Set it to TRUE and it will create relationships per the foreign keys defined on the database.