Changes in relationship

[ola1996]

Hello, 

I would ask you about Power BI connection with Dynamics 365 Business Central cloud. Is it possible that something change in relationship in last updates??

I was creating report using Business Central on premise and all relationship worked perfect, now when I change database to cloud (migrate data from on premise to cloud BC) I want to use exacly the same tables as before but relationships don't work properly. I need to have relationshisp one-to-many  but I can have only many-to-many.  Strage situation, please help. 

[danno]

is the data exactly the same?  sometimes the relationships flag this issue if there is a null in a key column at one end of the relationship. 

(Sorry Amit - overlapping messages :))

[ola1996]

@danno @amitchandak 

Thank you so much for your replay.

Yes, data are exacly the same. I was preparing report based on this data in January and even if I had null value in one key column I could create relationship one to many. Now I can't. Is there any option solve this problem? Now we need to implement this report on client side and we can't. 

[amitchandak]

@ola1996 , if you get a null value on the one side. It will become many to many