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.