postgres spatial datatypes

[vopatel]

I tried to import my postgres data using postgres connector in powerbi desktop. It seems powerbi is not able to import data for spatial datatypes like point, polygon etc. Any way I can import them without any issue?

[v-caliao-msft]

@vopatel,

Currently, in Power BI Desktop, you can determine and specify a column’s data type in the Query Editor, or in Data View or Report View:

Data types in Query Editor

Data types in Data View or Report View

So I am afraid spatial datatypes like point, polygon are not supported it Power BI currently. As Phil_Seamark suggested, you can convert those data to a supported data type and import into Power BI.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/

Regards,

Charlie Liao

[Phil_Seamark]

What do they look like when you import them?

Can you convert the data in postgres to a text format to then process accordingly in Power BI?

[vopatel]

When I import spatial object/columns in powerbi, all the values are null. Not sure how I can convert postgres spatial data into text format

[vopatel]

I tried to import my postgres data using postgres connector in powerbi desktop. It seems powerbi is not able to import data for spatial datatypes like point, polygon etc. Any way I can import them without any issue?