Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
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?
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
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?
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |