Relationships

[Jeroenvb1]

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