Issue regarding power bi report using Lookup column relationships'
I have imported all tables from a SharePoint list into Power BI and created relationships between them. The main table uses a real ID column, while other tables use lookup ID columns. The relationships are defined as one-to-many, with the main table's ID column linked to the lookup ID columns in other tables. When I use data from two tables in a Table visual, it works fine. However, when I add data from a third table, I encounter the error: 'Can't determine relationships between the fields.' How can I resolve this issue?"
