Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Issue showing no data when relations are set on a lower level

Hello, I have just started to use Power Bi for a customer of mine so I'm very new.

 

Now I want to show a list of the salesorders, with the orderdate, the linked delivery, with the delivery date, the linked salesinvoice, and so on. later on I would like to use articles to show the above information again in another list.

 

I have added a printscreen on how the relations are in our db.

 

the issue is that I can add salesorder nrs, orderdates, and then I have already an issue on showing the delivery nrs. 

I think it has to do with the direct link that is missing between salesorder and delivery table cause the link goes over the ordersubline and deliverysubline table.

 

Can someone please advice on how to solve this, cause I need this kind of relations in several reports.

Thanks in advance, Liesbet.

Need Help
Show and Tell

2 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous , 

    I can't reproduce your problem based on your relationship image, if possible,  could you please inform me more detailed information(such as your expected output and your simple sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.