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 trying to make heat maps for our CMMS (computerized maintenance management system). E.g. Which assets are needing repairs in what area the most.
I have connected Power BI to our sde SQL database.
Problem:
There are no latitude or longitude coordinates in the sde tables. The GIS guy here at work says ESRI finds the location using the "Shape" field which looks like "POINT (2306636.8429999985 14740070.512000002)." From what I can tell the "Shape" field is a reference to some underlying ERSI data which knows how to relate and display the data. SO, when I drag this field to the "Location" box in Power BI, some points show up, but are spread across the planet. Apparently Power BI does not know how to deal with "Shape" information.
Is there a way I can get the Shape data in a format Power BI would understand?
Any help would be appreciated!
Example of data
Hi @TJesse,
Though I'm not the expert of ArcGIS. The points here seems the special format of the Shapefile. Please refer to https://www.e-education.psu.edu/natureofgeoinfo/c4_p5.html Howerver, the Shapefile isn't supported by now. Please vote up this idea. You can also consult the GIS guy.
Best Regards,
Dale
I am trying to make heat maps for our CMMS (computerized maintenance management system). E.g. Which assets are needing repairs in what area the most.
I have connected Power BI to our sde SQL database.
Problem:
There are no latitude or longitude coordinates in the sde tables. The GIS guy here at work says ESRI finds the location using the "Shape" field which looks like "POINT (2306636.8429999985 14740070.512000002)." From what I can tell the "Shape" field is a reference to some underlying ERSI data which knows how to relate and display the data. SO, when I drag this field to the "Location" box in Power BI, some points show up, but are spread across the planet. Apparently Power BI does not know how to deal with "Shape" information.
Is there a way I can get the Shape data in a format Power BI would understand?
Any help would be appreciated!
Clip of availible data.
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.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |