Import geometry column using R on PowerBi

[Anonymous]

I'm trying to import a gdb file into my PowerBi using R as follows:

library(readr, quietly = T)
library(sf, quietly = T)
library(dplyr, quietly = T)
library(tidyr, quietly = T)

boundariesConstituencies <- st_read("C:/Borough_Councils/district_borough_unitary_region/district_borough_unitary_region.gdb", "district_borough_unitary_region") %>% 
  select(constituency = NAME) %>% 
  st_set_crs(27700) %>% 
  st_transform(4326)

I am able to read the gdb file and get the first column, but there is an error in the geometry column:

The error I get: "DataFormat.Error: We cannot convert this value from its .RData representation."

This script works just fine in RStudio.

Any ideas how to import the geometry into powerBI?

[Anonymous]

Hi @Anonymous ,

Please kindly refer to this similar post:

Solved: DataFormat.Error: We cannot convert this value fro... - Microsoft Power BI Community

Workaound:

values<-c(1,2,3,4,5)
df10<-data.frame(values)
library(dplyr)
df11<-combine(df10$values)
r<-3
result<-data.frame(combn(df11,r))
result

Best Regards,

Stephen Tao

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