topic Re: losing relation when changing the source from SQL to Snowflake in Developer

losing relation when changing the source from SQL to Snowflake

AliSafa — Thu, 14 Dec 2023 17:21:51 GMT

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

Re: losing relation when changing the source from SQL to Snowflake

lbendlin — Sun, 17 Dec 2023 15:26:50 GMT

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.

Re: losing relation when changing the source from SQL to Snowflake

AliSafa — Wed, 20 Dec 2023 13:36:07 GMT

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