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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

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
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors