Active Member
October 17, 2020
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
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)