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...
Power BI by default suppresses rows/columns without data. In your visual enable the setting "show items with no data" for both rows and columns values.
You will also learn that it is important which side of a table relationship you pick the key column from to put into your visual (difference between left and inner join, sort of).
Happy learning!