Forum Discussion
Failed to save modifications to the server when calling API
Hi everyone
I am getting the following error when I click "Apply Now" in power query.
Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references an unknown entity.
I have an advanced query I wrote that works perfectly in power query until I hit the apply button to go back to my report.
The query calls an API and using paging to get all the data before constructing my final table.
Does anyone know what this error is?
Thanks
Patto
17 Replies
Hi ian_teoh,
Thanks a lot for the solution, this is working perfectly.
File
Options
Options and Settings
Options
Preview Features
uncheck "Store datasets using the enhanced metadata format".
Same Problem. It was the solution. Thank you.
I had the same issue, but was nothing mentioned above, but then realised that the 'partition' relates to incremental refresh. (thanks to Daniel Otykier videos on Tabular Editor!) Once I removed the incremental refresh policies on all the tables, it allowed the Query to be applied successfully!
Hi Anonymous ,
I just came across this same problem when just messing around with some public info with the below M script. Not sure why this erroring as it loads the data ok in power query. Sorry I can't answer your problem but maybe someone can answer this one which may be the same as your problem.
let Now1 = DateTime.LocalNow(), Date1 = DateTime.ToText(Now1,"yyy-MM-dd"), Source = Excel.Workbook(Web.Contents("https://www.ecdc.europa.eu/sites/default/files/documents/COVID-19-geographic-disbtribution-worldwide-" & Date1 & ".xlsx"), null, true), #"COVID-19-geographic-disbtributi_Sheet" = Source{[Item="COVID-19-geographic-disbtributi",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(#"COVID-19-geographic-disbtributi_Sheet", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"DateRep", type date}, {"Day", Int64.Type}, {"Month", Int64.Type}, {"Year", Int64.Type}, {"Cases", Int64.Type}, {"Deaths", Int64.Type}, {"Countries and territories", type text}, {"GeoId", type text}, {"Pop_Data.2018", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Pop_Data.2018", "Pop_Data_2018"}}) in #"Renamed Columns"
I am experiencing the same issue but have narrowed it down to the following. If I replace the text of the web path "https://www.examplesite.com/testfile.xls" with a function fnPathFile does this dynamically then I get the error. Any ideas would be helpful
Web.Contents("https://www.examplesite.com/testfile.xls")
Web.Contents(fnPathFile)
fnPathFile returns: https://www.examplesite.com/testfile.xls
I had the same problem and none of the suggested solutions worked. I found that I had some nasty anti-patterns, where I had a calculated table having a relationship to a table included in the calculation. When I refactored to eliminate that, the problem disappeared.
The solution that worked for me was to delete files or programs stored on my local C disk, after that the message no longer appeared.
