Connection to IBM SPSS Data Collection

Hi Jozef_KaBa ,

I will try to reproduce the issue you encountered as much as possible.

Before solving the issue, you can consider using R or Python to import SPSS data instead. You can refer to these posts:

Import SPSS file in to Power BI – Using Python, savReaderWriter library – Data Analytics and BI Blog (amitzaveri.com);

Re: Import SPSS file into Power BI - Microsoft Power BI Community

---

 

Actually, via R, there is a possibility to at least load SPSS data. Unfortunately, variable labels seem to be lost, so I support this idea to improve Power Bi with a dataconnector for SPSS files, but this is a way to get data from SPSS to Power BI:

 

# 1. Install R https://mran.microsoft.com/open/

# 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

 

---

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.