Failed to save modifications to the server - custom function

[PBI_KLo]

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)

Any ideas?

-Kevin

[v-haibl-msft]

@PBI_KLo

From the error message, we need to check again to see if there is calculated column with wrong data type, and the registration field. It is better to share your PBIX file.

Best Regards,

Herbert

[PBI_KLo]

Hi Herbert,

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.

let
Source = Json.Document(Web.Contents("https://foobar.com" & meetingid & "&fromDate=" & "2016-7-1" & "&pagingCriteria.firstResultIndex=" & "0" & "&pagingCriteria.resultCount=" & "500")),
listRegistrationsResult = Source[listRegistrationsResult],
registration = listRegistrationsResult[registration],
#"Converted to Table" = Table.FromList(registration, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"email", "attendance"}, {"email", "attendance"}),
#"Expanded attendance" = Table.ExpandListColumn(#"Expanded Column1", "attendance"),
#"Expanded attendance1" = Table.ExpandRecordColumn(#"Expanded attendance", "attendance", {"entryTime", "exitTime", "durationInMinutes"}, {"entryTime", "exitTime", "durationInMinutes"})
in
#"Expanded attendance1"

Thanks

-Kevin

[v-haibl-msft]

@PBI_KLo

You can upload your pbix file to online file service like OneDrive and share it to me.

Best Regards,

Herbert