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
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:UsersCatalinDesktopAttendnace Sheets"),
File = Source{[#"Folder Path"="C:UsersCatalinDesktopAttendnace 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.
Dear Mr. Bombea,
Thanks for your reply,
I did edited the sample file and changed the location of the folder.
WIll take care of it in future,
Regds,
Tarun
