Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am creating new dataset "languages" with R script, loading data from SAV file
library(foreign)
languages <- read.spss("C:\\data.sav", to.data.frame = TRUE, use.value.labels = TRUE)
If I execute it in R-studio I receive data with correct characters, but in POWER BI desktop is everything crippled, I used also optional parameter reencode to choose different codepage but nothing has changed in POWER BI desktop
Thanks for help
Solved! Go to Solution.
you may need to convert to ANSI first, or specify the code page during read.spss
What's the native encoding of the .sav file, 65001?
Hello yes, 65001
you may need to convert to ANSI first, or specify the code page during read.spss
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |