Isolate a column

[abukapsoun]

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 stays as it is without being updated with the new values. 

I intend to do this so I can compare what has been modified on the list. 

Thanks,

[Anonymous]

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

[Greg_Deckler]

You could create a second query and then tag it to not refresh. 

[abukapsoun]

@Greg_Deckler

thanks
How can I tag it not to refresh?

[Greg_Deckler · Accepted solution]

Go into Query Editor, right click the query and uncheck "Include in report refresh".