Forum Discussion

Pieter_086's avatar
Pieter_086
New Member
5 years ago

Cannot upgrade to enhanced metadata

Hi All,

 

this new feature now seems permanent, which makes I cannot update my reports anymore:

I have no clue about the why on this error. But its on a query that has a certain folder as source.

 

Queries Metadata
Failed to save modifications to the server. Error returned: 'The Folder 'Transform File from C:\' is invalid because the parent folder 'Transform File from C:' does not exists in the Model. '.
Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I had the similar issue.

    The only thing I made to solve it is to rename in Power Query the Folder that was automaticly created by Power bi

    From : Transform File from c:/

    To Transform File from

     

    I hope it could help

     

    • ianharper's avatar
      ianharper
      Frequent Visitor
      5 years ago

      Thank you!!! I've been trying to figure this out for months now and the other suggestions weren't working. In my case the folder name had "\" characters in it which caused the issue.

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  ianharper ,

         

        Glad to hear that,could you pls mark the reply as answered to let more people to find the solution?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!

  • MattBossert's avatar
    MattBossert
    Helper II
    5 years ago

    Alright, I think I figured it out.  It seems there's definitely a bug in PowerBi when it tries to auto-convert to the new metadata format.  The issue is indeed with special characters in the Transform File functions.  To fix this issue, I did the following:

     

    • Open the impacted .pbix file
    • Go to Transform Data
    • Locate your query which calls the "Transform File" function
      • Find the steps in the query which specifically call the transform file function
        • For me, these steps were "Invoke Custom Fuction1" and all steps which referenced the "Invoke Custom Function1" step
    • Rename the file path part of the function name to something without special characters
      • In my case, the before and after code for this step are below replace <server name> with anything you want without special characters:
        • BEFORE:  = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from \\<server name>\<path>", each #"Transform File from \\<server name>\<path>"([Content]))
        • AFTER:  = Table.AddColumn(#"Filtered Hidden Files1", "Transform File from <server name>", each #"Transform File from <server name>"([Content]))
    • Now you need to go up to the "Transform File" function and make the same changes there anywhere the old function name is referenced - from the function name to steps within the function itself.

    This was a total pain to do once, let alone the 20 more times i'll have to do it in various reports, but for me, this resolved the issue and I can now refresh my data from within PBI Desktop.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      I Tried the above steps and removed all special characters still not working for me
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have exactly the same problem......

  • MattBossert's avatar
    MattBossert
    Helper II
    5 years ago

    Same problem here as well.  From my error message is seems there are characters in the file path that PowerBi isn't handling well.  Worked before the enhanced metadata upgrade just fine though.