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.
I am using an R script to download a zip file, unzip, and load into Power BI.
This is the code i am using:
temp <- tempfile()
download.file("https://",temp, mode="wb")
input <- read.csv(unzip(temp),sep=';',header=TRUE,stringsAsFactors = FALSE)
unlink(temp)
The columns with longitude and latitude are shown with a dot ".":
But when file is uploaded to Power BI, this changes to comma, ","
We are based in Norway, and comma is the decimal separator in Norway.
Solved! Go to Solution.
I managed to make a fix by using colClasses="character".
All columns are now shown as text, but i can probably work around it.
I managed to make a fix by using colClasses="character".
All columns are now shown as text, but i can probably work around it.
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.