Forum Discussion
Solved
Name Not Updating in Power Query When Overwriting Source File
I'm trying to rerun my Power Query after updating a source file but whenever I run it, I get this error: Steps to update source file: Downloaded an updated source file from an internal da...
- In the step where you save the csv as xlsx, what is the name of the worksheet? Make sure it matches what is in your query.
In the step where you save the csv as xlsx, what is the name of the worksheet? Make sure it matches what is in your query.
- Thank you! I don't know why I didn't think to check the sheet name. I appreciate your help!
There is also a way to set up the query so the tab name doesn't matter. When you choose Data, Get Data, From Workbook, a window opens showing some details about the workbook. Make sure you click the main branch of the tree that is displayed:
then click "Transform data". Power Query will show the elements of the workbook in a table, take these steps:
- Filter the "Kind" column for "Sheet"
- Filter the Name column for some text filter like "Begins with"
- To make sure we're only importing one sheet, click "Keep rows", "Keep Top Rows" and choose to keep only 1 row
- Consider if these steps will always give you the sheet you need. If not, change the above steps, these are just examples!
- Click the tiny button with the left and right pointing arrows next to the Data heading in the table.
