Forum Discussion
Solved
Isolate a column
Hi Dears, I have a sharepoint list as my power Bi query. How can I duplicate a certain column and isolate it from the refresh? So whenever the sharepoint list is updated, this duplicated row stay...
Go into Query Editor, right click the query and uncheck "Include in report refresh".
Hi abukapsoun,
If you want to create a new table with a duplicate column you can select new table in the data view with formula:
Newtablename = DISTINCT(YourTable[DesiredColumn])
Although you create a duplicate in a new table this way I am not entirely sure it will be isolated when the original table is updated. You would nee to test if that works.
Regards,
L. Meijdam