Forum Discussion
Solved
How to Add a New Column to an Existing Power Query Without Breaking the Report?
Hi everyone, I've been working on a report that pulls data from various sources, and after sharing it with management, they requested an additional column from one of these sources. The problem I...
This is really dependent on your data model and how much data you're actually bringing in. When you say it breaks the enitre setup trying to add one column, can you share an example of the error you're getting?
If this is just a one-off column that you need to add I'd probably add it as a calculated column with DAX as a quick fix.sirbaklava give this a try, and if you encounter any issues, let me know.
- Open Power Query Editor.
- Identify the step where you need the new column.
- Add the column using "Add Column" options, or adjust the source step to include it.
- Refresh the data and validate the report.
Did I answer your question? If so, please mark my post as the solution!
Your Kudos are much appreciated! Proud to be a Resolver III !
sirbaklava give this a try, and if you encounter any issues, let me know.
- Open Power Query Editor.
- Identify the step where you need the new column.
- Add the column using "Add Column" options, or adjust the source step to include it.
- Refresh the data and validate the report.
Did I answer your question? If so, please mark my post as the solution!
Your Kudos are much appreciated! Proud to be a Resolver III !