Failed to save modifications to the server - custom function
I am receiving a:
"Failed to save modification to the server. Error returned: 'Expressions that yield variant data-type cannot be used to definie calculated columns. OLE DB or ODBC error: [Expression.Error] The field 'registration' of the record wasn't found."
The offending query is one that retrieves via HTTP a list of ids, against which I invoke a custom function. The custom function is also an HTTP request, using that id in the URL to retrieve a json formatted table.
This is perplexing for a variety of reasons:
I am not saving anything to a server AFAIK
The custom function example doesn't give an error
The preview of the final query works
There is no calculated column
I don't see a 'registration' field (but will look further)
I found "registration" in the query, and I suspect for some ids there are extra fields with incorrect data types. However, I dont see a calculation. What's the best way to send you the PBIX? Here's the offending query with modifications for privacy.