loading an SPSS .sav file using the following script found elsewhere in this community - loading spss data with R
let
Source = R.Execute("library (RevoScaleR)#(lf)spssFile <- file.path(""\\file path\\.sav"");
#(lf)tempFile <- ""\\file path\\temp.xdf"";
#(lf)tempData <- rxImport(inData = spssFile, outFile = tempFile, overwrite=TRUE);
#(lf)spssData <- rxFactors(inData=tempData, sortLevels=TRUE,factorInfo=c(""rwkrsonea""));"),
spssData1 = Source{[Name="spssData"]}[Value]
in
spssData1
the initial load is fine and i am able to manipulate the data in power query. however, if I close and re-open the file, I am no longer able to refresh or edit the powerquery script (to eliminate uneeded columns, alter data-types etc)
I get the following error - nothing about the source file or any other data has changed.
DataSource.Error: ADO.NET: R script error.
Error in doTryCatch(return(expr), name, parentenv, handler) :
Error: Call to 'uncompress' failed. Input data was corrupted or incomplete.
Calls: rxFactors ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call
Execution halted
Details:
DataSourceKind=R
DataSourcePath=R
Message=R script error.
Error in doTryCatch(return(expr), name, parentenv, handler) :
Error: Call to 'uncompress' failed. Input data was corrupted or incomplete.
Calls: rxFactors ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call
Execution halted
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Radio.RScriptRuntimeException
if I start a fresh powerBI file, with just the R script as the source (and not a copy of the power query/M code) then it works fine,
I feel like there's a parameter/cache issue, but I don't know what to change. Please help
