Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost 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 stay...
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".

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

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