Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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,
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.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.