Forum Discussion
Update a duplicate reference table with new columns?
Community SupportHi Anonymous
As tested, it can work on my side.
Could you show your example data?
I use the example data as below
| question1 | question2 | question3 | question4 | question5 |
| yes | no | yes | yes | no |
I right-click on the table, select any option below to get a new table
1. copy, then paste the table to get a new table
2. click on "reference" to get a new table
3. click on "duplicate" to get a new table
unpivot all question columns by selecting all question columns and "Transform"->"Unpivot columns"
(don't select "unpivot only selected columns",
In my test, i only have question columns.
If you have more columns, some columns doesn't need to unpivot,
please select the columns don't need to unpivot, then select "unpivot other columns" )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not a very user friendly I would say
- v-juanli-msft
Hi Anonymous
When your data source add new data, just click on "refresh all" button in Power BI Edit Queries, the new data would add to the table.
You could unpivot all columns by adding an index column, selecting this index column,then select "unpivot other columns", so that new columns would be automatically perform "unpivot columns" function.
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
Best Regards
Maggie