Forum Discussion
Issue with PowerQuery and lookups
Hi, I am new to PowerQuery and have managed to build a finance dashboard for my manager. We don't work with a proper database so I had to create my own lookup tables to show industry and region again...
Thank you for that. I am not using PowerBi, I am using PowerQuery in Excel. Where do I find the setting to say show items with no data?
The one online course I did demonstrated that I needed to drag the Client ID from my data set (with multiple transaction items) to the client id of my lookup.
My bad, I made the wrong assumption. Instead of "now" I read "not" 😞
If you see data "multiplying" that means you are missing a connection in your data model between the tables that your data comes from.
Can you post a sample file that illustrates your issue?
