Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
8 years ago
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 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,

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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