Log In
Register
Home
Active Member
October 17, 2020
Offline
Dear Sir/ Madam,
I am new to power query and I tried to create a dashboard using it. Now I am facing an error which I am not been able to resolve. Kindly assist me in this.
Attached is the folder, further in the applied steps up to removed other coloumn1 it is working but from the next step(Expanded Table column 1) it shows error.
Thanking you in advance
Regards,
Tarun Dhiman
See Answer
November 8, 2013
Offline
Did you edited the Sample File query?
Normally, this should be a sample file, not a folder:
Adjust the path to your file:
let
Source = Folder.Files("C:\Users\Catalin\Desktop\Attendnace Sheets"),
File = Source{[#"Folder Path"="C:\Users\Catalin\Desktop\Attendnace Sheets\",Name="02 Jan.xlsx"]}[Content]
in
File
Automatic combiner is not yet as flexible as it should, if you need flexibility you should use a custom solution.
Answers Post
1 Guest(s)
