Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need to concatenate/show refreshed values

Hi Mentors,

Looking for a solution for the below problem. 

I have a value which is changed for every refresh. Upto this, it is fine. THis value is coming from a POST method. So, I am able to manage it using Power query post methid.

Now I need to concatenate this new values every time and display. Like, first time I am getting "a7" and next time I am getting "b9" and again after refresh I am getting "g3". I need to show these values. I can concatenate these values or I can show them as table rows.

Any help is much appreciated.

Need Help
  • smpa01's avatar
    smpa01
    5 years ago

    Anonymousyou can write a powershell script to store your dataset upon each refresh in a folder to archive and then query the folder and compare the archived value.

5 Replies

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hello Anonymous 

     

    this is not possible with Power Query. Every time you refresh, your dataset is completely recalculated, and you miss the data from a previous refresh


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Jimmy....Its pretty helpful. Just one question, can it be possible to do using Power Query? I was trying with Table.insertrow but so far no result.

    • Jimmy801's avatar
      Jimmy801
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Hello Anonymous 

       

      what would you like to do? As I was writing that incremental refresh in Power Query is not possible at all. So every time you hit the refresh-button, your data is recalculated and therefore you loose all your previous data.

       

      BR

       

      Jimmy

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Jim, understand. Actually I was trying to insert the refreshed value to another table after each and every refresh. Trying to do it using Power query but again, as you already said, its not possible.

        Thanks for your help.

         

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymousyou can write a powershell script to store your dataset upon each refresh in a folder to archive and then query the folder and compare the archived value.