topic Power Query incorrect refresh in Power Query

Power Query incorrect refresh

Simon_29 — Fri, 08 Oct 2021 06:40:48 GMT

Hello,

Please, I have such a problem that I created such a Power Query as shown below. The problem arises when I change ORDER_NUMBER to other numbers, after refreshing the query, it always throws back the numbers I worked with in the past. So the table never adjusts to new inputs and does not return the required outputs.

Thank you very much for your help.

Re: Power Query incorrect refresh

ImkeF — Fri, 08 Oct 2021 06:55:58 GMT

Hi Simon_29 ,
having difficulties to understand what's actually going on from your description,
but if you are removing duplicates in your previous steps, this could be the reason:
Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community

Re: Power Query incorrect refresh

v-kelly-msft — Mon, 11 Oct 2021 08:52:58 GMT

Hi Simon_29 ,

How do you change the order number?Could you pls paste your whole M codes?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Re: Power Query incorrect refresh

Simon_29 — Mon, 11 Oct 2021 10:03:55 GMT

Hello,

Thank you very much for your help, but I have already solved it myself. I made the mistake of directly overwriting the Power Query generated table with the new data, and I didn't even realize that I was missing the source table and that I needed to overwrite the data in it.

Beginner's error. Thanks for your time.

Re: Power Query incorrect refresh

Anonymous — Tue, 28 Jun 2022 18:34:30 GMT

Hello Simon,

I'm a newbie to Power Query as you were in the past. I think I'm making the same mistake like you, because I also don't get new data after refreshing the source table. Can you explain me in a step by step explanation, how you solved the problem?

Thanks in advance

Re: Power Query incorrect refresh

Simon_29 — Wed, 29 Jun 2022 05:48:46 GMT

Hey,

I made the mistake described above.
I made the mistake of directly overwriting the Power Query generated table with the new data, and I didn't even realize that I was missing the source table and that I needed to overwrite the data in it.

That was just a newbie mistake. I was refreshing wrong table. make sure your new data is always in the source table. They cannot be outside the scope of the table, they must be part of.