Forum Discussion
Solved
swapping data source excel file?
Hello, This seems pretty simple but I keep hitting a wall and am not sure how to fix it. I want to keep all my visuals and graphs the same, but need to swap out the excel file as the data source. ...
Proposed Solution:
Replace the Source File
New Excel file:
- Must have the same sheet names
- Must have same column structure
Apply these steps:
- Go to Transform Data
- Select the query (for example: Treatments tab)
- Click the Source step (on the right under Applied Steps)
- Click the (gear icon)
- Change the file path to the new Excel file
- Click Close & Apply
If this helps, ā Mark as Kudos | Mark as Solution| Help Others
You need to edit the queries that connect to the data and delete any reference that they have to these 'missing' columns. Most likely you'll find them in steps that change data types or delete columns. Can't tell without seeing the M-code.