Forum Discussion
Relationships
Hi all,
I am trying to load sales and budget data into PowerBI from Dynamics NAV. For this, i have created three queries, customers, customer ledger entries, article budget entries and one Alldates excel list. Eventually i want to graphically represent for each customers the sales and budget per month.
So far, so good ive loaded them into PowerBI. The next thing i try to do is create relationships between these four datasets. It works perfectly fine in powerpivot, as you can see below, but when i try the exact same thing in powerBI, it does not work. I cannot make a 'closing' set of relationships. Can somebody help me with this?
Thank you in advance,
Jeroen
Try playing around a bit with the Cross Filter Direction on each relationship, setting them to Single, as opposed to Both, in this situation might work. That might allow you to define the relationships without making any of them inactive. Of course once you get them defined be sure to check the interactivity on the visuals you have to ensure they are reacting as necessary for your usage scenario.
11 Replies
Jeroenvb1 for each relation that you create in power bi make sure you set cross filter direction to Single and this should let you create all relations. If not please post what error you get when creating the fourth one.
Thank you for your response Ankipatira.
I can create the relationships seperately up to three relationships, but not all four together. It seems like PowerBI does not want to create a closing circle which is strange because powerpivot does not give this error. See a screenshot of the error below:
Tjena Jeroenvb1
Problem is occuring because filter is getting passed to other tables.
Can you do following ?
Create another Datum table, a copy may be(call it Klanten Date), and create realtionship of it with Klanten. Kind of breaking the loop.
Hope it helps you !
Also provide some sample data here so we can mimic your problem.
BR,
/Achin
