Create a Data Connector for SPSS format files

This would help those of us in marketing research.

Actually, via R, there is a possibility to at least load SPSS data. Unfortunately, variable labels seem to be lost, so I vote for Microsoft to build a data connector, but this is a way to get data from SPSS to Power BI: # 1. Install R http://aka.ms/rclient/download # 2. Install Microsoft R Client https://msdn.microsoft.com/en-us/microsoft-r/r-client-get-started # 3. Now go to PowerBI, go to Get data > More > Other > R script and copy/paste this R script: spssFile <- file.path("d:\\yourpath\\yourfile.sav"); tempFile <- "c:\\temp\\temp.xdf"; tempData <- rxImport(inData = spssFile, outFile = tempFile, overwrite=TRUE); spssData <- rxFactors(inData=tempData, sortLevels=TRUE,factorInfo=c("weegvar")); # In the first line, be sure to enter the path to your SPSS file and use double slashes (\\) # In the last line, enter a variable in your dataset to sort on # Reference and more info: https://msdn.microsoft.com/en-us/microsoft-r/scaler-user-guide-data-import

Would like a connector for SPSS with Power BI

Hello, I have tried this one, but get a failure... Details: ADO.NET: R-scriptfout. Error in doTryCatch(return(expr), name, parentenv, handler) : Could not open data source. Calls: rxImport ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call Execution halted I have installed Windows R client en R Studio. Do you know a solution? I have no experience with R. Greetings Charel

Hi everyone, j I tried via R , but it doesnt work, show me this error: Detalles: "ADO.NET: R script error. Error in rxImport(inData = spssFile, outFile = tempFile, overwrite = TRUE) : no se pudo encontrar la función "rxImport" Ejecución interrumpida Could someone help me please? thanks

The fundamental problem is the labels. Importing data is easy. Importing variable and value labels is really really hard. I use a lot of categorical data and without labels any dashboard is meaningless.

Create a Data Connector for SPSS format files

SPSS data can be imported using Python script. Please visit this blog for detailed steps https://amitzaveri.com/2020/06/04/import-spss-file-in-to-power-bi-using-python-savreaderwriter-library/

I don't understand why this hasn't been done a long time ago. Microsoft wants us to move from apps like Stata and SPSS, yet there is no easy way to bring pre-coded data (data that is categorized). IBM Statistics (formerly SPSS Base) is an app that offers all data to be easily coded with labels to correspond with its values. For example, it is trivial to set for the Variable "Overall_Satisfaction" to set the following parameters: 1 - Not satisfied at all 2 - Slightly satisfied 3 - Mostly satisfied 4 - Satisfied 5 - Extremely satisfied It is not clear how to bring in labels that would correspond to values in Power BI. Surely there must be people at Microsoft who are doing market research and dealing with coded variables in their studies. I would switch from SPSS in a second if I could import an SPSS file and keep the value labels intact with each variable and corresponding values.