Solved: losing relation when changing the source from SQL ...

AliSafa · ‎12-14-2023

Hi folks,

we have a Power BI report connected to the SQL server,

we need to remap this report to Snowflake instead of the SQL server,

in the snowflake we have the same tables as SQL(same data, same data types, same column headers, etc)

when we remap the power BI report to Snowflake, we lose some of the relations in the model!!

Has anyone had the same experience? any advice?

thank you

lbendlin · ‎12-17-2023

in the snowflake we have the same tables as SQL(same data, same data types, same column headers, etc)

Most likely that is not true. They have to be EXACTLY the same, down to the spelling of the column name and the data type of the column. If there is a minimal difference you will lose not just the relations, but also the measures, groups, and sortings.

View solution in original post

lbendlin · ‎12-17-2023

in the snowflake we have the same tables as SQL(same data, same data types, same column headers, etc)

Most likely that is not true. They have to be EXACTLY the same, down to the spelling of the column name and the data type of the column. If there is a minimal difference you will lose not just the relations, but also the measures, groups, and sortings.

AliSafa · ‎12-20-2023

thats right, now it is fixed, some of the columns were not exactly the same as the original source, so we changed them in snowflake to be exactly the same(mirror copy) as the original sql tables and when we remap now, no relation lost. thanks