Forum Discussion
Power BI not bringing correct relationships from SQL Server?
Hi DMatus,
Which auto-detect option has you disabled, is the following one?
File -> Options & Settings -> Options ->Current File-> Data load
I tried to disable it and it worked with no additional relationships created when loading new data. Here I only kept the first option selected under Relationships, please also take a try to select the Update relationships when refreshing Queries and see if it would make any difference.
Also I created with two new table with no values (configured the relationship (* to 1) in SQL SMS), this time Power BI shows the relationship as 1 to 1 with Auto-detect selected, I will make some further test and discuss this with others, will update here if there are any new findings.
Regards
@Habib Yes, changing the relationships to 1-* indeed fixes the refresh issue, it's just kinda cumbersome when your fact tables have too many dimensions :P
v-micsh-msft Yes I've tried enabling and disabling that button, it had no effect either way, sadly. It did not change the relationships before refreshing either, so an error is produced.
I sent a frown and was told they would try to fix it, in the meantime I just went and changed every 1-1 relationship to 1-* manually (which took forever!), thank you both for your time :)
Hi DMatus,
Apologize for the late response.
I think the issue here should be related with no Data reference, so Power BI just take the 1:1 relationship instead.
I will try to report this issue from my side.
Regards
