Forum Discussion
Solved
Lookup in query editor
Hi All, I have the following data I then created a reference of this table and removed all columns except Employee to create the Employee table. I removed duplicate values and created an i...
Hi again Jos13 ,
Forgive me if I am not getting your point but when I recreate your steps, duplicating the Sales query to create the Employees Table, I get what I would expect:
Please detail further what prevents you from proceeding this way in order to assist you.
Hi Jos13 ,
I understand both queries are connected to the same Source and is there where you update the Sales table. Is this correct?
You are right Payeras_BI
I was entering the data directly into Power BI using Enter Data from the Home ribbon. My bad.
I tried data load from an Excel file and it worked perfectly.
Thank you so much! I really appreciate it 😊