Forum Discussion

apods1979's avatar
apods1979
Helper I
6 years ago
Solved

Failed to save modifications to the server. function Python.Execute

Complete error: Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references unknown variable or function 'Python.Execute'.   I have this err...
General Comment
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi apods1979 ,

     

    Sorry for our poor python knowledge, Is "dataset[t]=XXX" a nested tables? Based on this document, Nested tables are currently not supported. 


    Best regards,

     

  • athulbabuakb's avatar
    athulbabuakb
    6 years ago

    I had a similar problem. Just go to Option > Preview features and uncheck Store dataset using enhanced metadata format.
    That should do the trick.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey guys, really struggling with this error, any other ideas on how to fix it? I've already tried "Store datasets using enhanced metadata format".

 

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous , Paulien_ ,

 

Could you please try the following steps to see if this error can be reproduced:

  1. Backup the origin pbix file
  2. Install the latest version of Power BI Desktop, (if you are using MS Store version, upgrade in MS Store)
  3. Turn off the Preview Feature "Store datasets using enhanced metadata format" in options.
  4. Restart Power BI Desktop and create a new blank pbix file
  5. Try to copy the queries from origin pbix file to the new file when save the query (instead of using the old pbix file), or just write new query in the blank pbix file.
  6. Then verify if this error occur in the new pbix file

 

If it is an urgent issue, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/


Best regards,