Day 01 #30DQUERY in repeat

This morning when I checked again all the information and some of the other outcomes I realised I had missed the instruction that everything should be done in the Power Query Editor and not to make visualisations.

So, lets go and repeat Day 1

My Route

  • Open Power Query Editor
  • Import via the option SQL Server the Entity <DimEmployee> op my computer
  • Follow the recommended practice
    • Filter the BirthDate at 1974
    • Merge the 3 columns that have name parts into 1 new column [FullName] and here it goes wrong. I use the option Merge Colums in the Power Query Editor and then the option View Native Query greys out.
      I have been looking around on the internet to find a solution, but I cannot find it. So, I stop the challenge of today and wait for an explantion on Day 10 and then will see if I can redo Day 1
  • Remove all the not selected columns so only the 4 needed are left.

My Result