Results 1 to 2 of 2

Thread: Power Query_Refresh data_Not populating

  1. #1

    Power Query_Refresh data_Not populating



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,


    I am newbie in using power query tool. I want to combine two sheets data in the same work book and then I want to apply pivot
    So I used power query for two tabs and then append to combine both tables.

    However, I will keep adding data to the 2 sheets which I combine, but whenever I refresh the query, newly added data will not be shown.


    Please help me on this.


    Thank you

  2. #2
    It might be that your file is corruped - as it will not update with new data.

    There are a number of operations you simply should not do:

    - Change the table name in Power Pivot
    - Rename an imported column in Power Pivot
    - Delete an imported column in Power Pivot

    They will corrupt the file. See the book "M is for (DATA) Monkey".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •