Forum Discussion

ola1996's avatar
ola1996
Icon for Helper I rankHelper I
5 years ago

Changes in relationship

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. 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      ola1996
      Icon for Helper I rankHelper I
      5 years ago

      Anonymous 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.