Forum Discussion

PBI_KLo's avatar
PBI_KLo
Helper I
9 years ago

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: [Expre...
Data Modeling
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

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's avatar
PBI_KLo
Helper I
9 years ago

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's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    PBI_KLo

     

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

     

    Best Regards,

    Herbert