losing relation when changing the source from SQL to Snowflake

[AliSafa]

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 · Accepted solution]

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]

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