Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Simon_29
Helper II
Helper II

Power Query incorrect refresh

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.PHOTO_1.pngPHOTO_2.pngPHOTO_3.png

Thank you very much for your help.

1 ACCEPTED SOLUTION
Simon_29
Helper II
Helper II

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.

View solution in original post

5 REPLIES 5
Simon_29
Helper II
Helper II

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.

Anonymous
Not applicable

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

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.

v-kelly-msft
Community Support
Community Support

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!

ImkeF
Community Champion
Community Champion

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

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.