Power BI relationship between Vendor Ledger Entry and G L Entry tables

diegolrz

I am trying to build a dashboard that shows GL Account expense by Vendor. However, I am having trouble creating a relationship between GL Entry and Vendor Ledger Entry tables.

If I create the relationship based on the Entry No, it works but it only reports the Accounts Payable account and not the expense accounts.

I also thought that since the entry numbers are consecutive I might be able to look for the next entry no, this works when there was only one GL Account entered in the purchase invoice. If there are multiple I am SOL.

Power BI is not letting me create a relationship based on Document No. The error reads: "You can't create a relationship between these two columns because one of the columns must have unique values."

Any thoughts on how to get this working?

Thanks,