Forum Discussion
reffr
10 years agoNew Member
Import SPSS file into Power BI
Has anyone been able to easily import an SPSS .SAV file into Power BI? Any help would be greatly appreciated. I am a Power BI newbie so please don't judge! Thanks in advance for your help. Rob...
Anonymous
7 years agoNot applicable
has anyone overcome the issue where variable labels are not being imported into Power BI? I run the same script in R and variable labels come across but not in Power BI. The code I'm using is:
library(foreign)
dataset = read.spss("C:\\SPSS data files\\telephone2018.sav",use.value.labels =TRUE, to.data.frame =TRUE, full.names = TRUE )
Am I missing anything?
Any help much appreciated.
Thanks
Jo
jamesperry
7 years agoFrequent Visitor
I've used the Haven package as described https://rstudio-pubs-static.s3.amazonaws.com/466787_84982191b86e4591bfcee776e498a6d4.html
Worked perfectly.
James