Forum Discussion
Power BI not bringing correct relationships from SQL Server?
I have an empty Fact Table which has many-to-one relationships with many Dimension tables in my SQL Server, however, when bringing these tables to Power BI, all relationships show up as 1-1, so when ...
@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