Connection to IBM SPSS Data Collection

[Jozef_KaBa]

Hi all,

My I kindly ask you to advise, how to connect PBI to IBM SPSS Data collection (formally called  Dimensions)?

I have used OLE DB, but when I try to connect via IBM SPSS Data Collection DM-2, and pres "Next", my PBI crashes and automatically closes itself.

Thanks a lot.

[Icey]

Hi @Jozef_KaBa ,

I don't have IBM SPSS Data collection. So I can't test for you.

Since PBI crashes and automatically closes itself, could you close all other unnecessary process and test it again?

Or, you can try to use the latest one published on 5/12/2021 and test it again.

Best Regards,

Icey

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

[Jozef_KaBa]

Hi Icey,

I have uploaded my PBi version to May 2021, but the error stil remains.

I have reported it to PBi center. Many thanks. Jozef

[Icey]

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...;

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.