Forum Discussion
Load to dynamic Sheet / Table name when importing from files using Power Query
I have a reporting need each month to import data from a few csv files and store the data in a workbook with each new month of data on a new sheet and table within the current workbook, is this possi...
Hi DavePerks ,
You can always import the first sheet of the excel regardless of its name.
Check this: Import first sheet of an Excel workbook into Power Query, regardless of its name – SQL Ryan
Thanks for taking the time to respond, but this is not the issue/goal I'm trying to resolve. I have no issues importing and manipulating my external sheets and CSV files in PQ, but rather the final sheet/table name that is output to Excel at the very end. I was looking for a way to dynamically create a new sheet/table (the PQ Name) but I'm yet to find a way. I also need to stay away from Macro/VBA due to company limitations/policy. I'm starting to think it's not possible using PQ.