Forum Discussion
update canceled from transform files
Hi everybody,
I have an update problem and I can't find the solution on the Internet.
I think I've made a big mistake and i can't fix it.
I'm using Power BI and made my changes on Power Query.
Usually when I make a change in "transform sample file", it integrates the change directly into "transform file".
but I seem to have deleted the direct update and I don't know how to put it back.
Does anyone know?
Many thanks in advance
Before :
Now :
Hi Elodie
You can create a new function from "Transform Sample File" query and give the new function a different name from "Transform File", e.g. "newFunction". This new function will be binded to "Transform Sample File".
Then modify the step "Invoke Custom Function1" in the main query to invoke this new function instead of the old "Transform file". The outcomes are in the column "Transform File". You can check the results in the tables.
The old "Expanded xxxxxx" step may have some problem. You can remove that step and expand the table column "Transform File" manually.
Reference: Relinking Transform Sample File query with function in Power Query? - Microsoft Community Hub
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
8 Replies
You should have received a warning that this will happen. There is no way to undo the break, you would have to start over.
However, you can also examine the code and then implement the same yourself. It will be much more efficient that way (without reading the first file twice etc).
Thank you so much for your answer !
It's quite possible that I got a warning message and clicked too quickly without meaning to.
Could you please tell me which code I need to implement? and where i need to implement it ?
thank you !!
If you went through the code and can't yet fully follow what it does it might be quicker for you to start over.
