cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Simon_29
Helper I
Helper I

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 I
Helper I

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

3 REPLIES 3
Simon_29
Helper I
Helper I

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

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
Super User
Super User

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors