cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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 

16 REPLIES 16

Thanks @gooranga1 
Yeah as per above, the issue was a bug in one of the preview features I had turned on.
As soon as I turned it off, all was well in the world.
Cheers

Anonymous
Not applicable

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.


Frequent Visitor

Unforturnatley turning off the preview feature didnt fix the issue for me with desktop version May 2020.

I'm doing something similar where I'm applying a custom function to a column in a table that returns more rows.  I most likely will have to resort to using Python

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

Helper V
Helper V

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.

It was the solution. the same problem Thank you

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors