Forum Discussion
Update a duplicate reference table with new columns?
I have a table from SharePoint 2016 with columns of test questions. To be able to report on the test question columns, I made a reference copy of that table and in the new table, I unpivoted all the...
I was able to get it to work. I had to go into Advanced Editor and manually add the new columns on both tables. Challenging part was some of the column titles were very long and had a / in them so adding the full title didn't work. I had to create a new table with the new columns just to see how PBI renamed them.
Not a very user friendly I would say
Not a very user friendly I would say
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