Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

chippy-chip

Why Does PBI Load JSON Polygons as Individual Points Across Multiple Files?

Submitted by on ‎11-05-2024 10:51 AM

I'm creating a custom map in JSON and it works flawlessly at showing my polygons on mapshaper.org, geojson.io, jsonlint.com, and geojsonlint.com, but when I load it into Power BI it only shows up as points. Why would that be? My version is updated to January 2024 and I have no third-party plugins/extensions due to group security policy. 

 

I've even gone as far as to test someone else's JSON file in PBI located here

, and it too shows each coordinate pair as a single point such as below.

rawrjson.PNG

 

Thanks ahead of time!

 

 

Status: Investigating

Hi  @chippy-chip ,

 

Power BI expects coordinates in the order of longitude, latitude. If your coordinates are in the reverse order (latitude, longitude), this could cause issues with rendering.
Please verify that your GeoJSON file explicitly defines the geometries as polygons. if the geometries are not correctly defined, Power BI might interpret them as points. Ensure that the "type" property in your GeoJSON is set to "Polygon" or "MultiPolygon".
In the Visualizations pane, select the map visual and then go to the Format pane. Check the settings under Shape and Map styles to ensure that polygons are enabled and correctly configured.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎11-05-2024 10:27 PM
Status changed to: Investigating

Hi  @chippy-chip ,

 

Power BI expects coordinates in the order of longitude, latitude. If your coordinates are in the reverse order (latitude, longitude), this could cause issues with rendering.
Please verify that your GeoJSON file explicitly defines the geometries as polygons. if the geometries are not correctly defined, Power BI might interpret them as points. Ensure that the "type" property in your GeoJSON is set to "Polygon" or "MultiPolygon".
In the Visualizations pane, select the map visual and then go to the Format pane. Check the settings under Shape and Map styles to ensure that polygons are enabled and correctly configured.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses