The Day I Been Dreading

Question

I knew this day would come:&nbsp; I have a source file (Excel) that I get every week and load to Power BI.&nbsp; Two new columns have been added to this file, and will be included in all files going forward.&nbsp; I need these columns for reporting.&nbsp; How do I successfully refresh this file and bring the new columns into my reporting?&nbsp;Thank you,&nbsp;

pauldbrown · Answer

Select the whole data range in the file and make it a table (ctrl + t). Reference this table in the import phase in PQ &nbsp;(you can create a new query to import the table and then copy the relevant M Code and substitute the corresponding M code in the original query)
By importing a table from Excel, any rows or columns added will be included in the import phase in PQ

anonymous · Answer

Thanks, Paul.This is a file that I will upload weekly or daily.&nbsp; I&nbsp; don't want to be touching it everytime I want to refresh.&nbsp; Is there another way?

pauldbrown · Answer

How is the Excel file created? Would saving it as a csv file be an option?

anonymous · Answer

Saving as a CSV is not an option because I have 6 months worth of daily files that exist in .xls format and they would all need to be converted.&nbsp;

pauldbrown · Answer

Or you can create a new query to import the new files (saved to a different folder) and then append them in Power Query, no?

Forum Discussion

The Day I Been Dreading

7 Replies