Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
86
Views
Topic starter
Hi guys
I have an issue with the lesson 7.03. PowerQuery doesn't recognise my syntax:
let
//Get text or cvs files from a folder
path = Excel.CurrentWorkbook(){[name="PathTable"]}[content],
Source = Folder.Files(Text.Combine({Path[FolderPathColumn]{0} ,"Excel Course with Mynda"}, ""))
in
Source
It says the name 'Path' wasn't recognised. Make sure it's spelled correctly.
In addition, when I write in the editor the content assistant is off.
I'm open to suggestions. Thanks 🙂
Posted : 20/05/2023 11:53 am
Hi Dario,
Remember, Power Query is case sensitive. You have named the step 'path' lower case and you're referencing it with 'Path' upper case.
Mynda
Posted : 20/05/2023 8:47 pm