Forum Discussion

Elodie's avatar
Elodie
Regular Visitor
2 years ago
Solved

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. ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Elodie's avatar
Elodie
Regular Visitor
2 years ago

it would be much simpler for me to integrate the code, I have 19 different folders to reload and about 50 measures to recreate if I have to start from scratch. As much as I can copy and paste the code to clean up my Power Query files, for the DAX formulas I'd have to start from scratch, which would take up an enormous amount of time

I can manage the code, I already tried to add "updatedquery" (found on a forum) but it didn't work.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

  • Elodie's avatar
    Elodie
    Regular Visitor
    2 years ago

    Hi Anonymous 
    Thank you so much for your reply !!!! I have just seen it !
    II'm going to test your solution right away!
    thanks again!
    Best regards,
    Elodie

  • Elodie's avatar
    Elodie
    Regular Visitor
    2 years ago

    Hi again,

    Anonymous 

     

    thanks so much i am so relieved and very grateful that you took the time to write me this solution! thank you !

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Glad it helps! You are welcome.