Get data > ArcGIS

1478
2
10-12-2022 04:56 PM
Status: Open
TimMinter
Occasional Contributor III

Simple.  Easy.  Get data.

As of 10/12/2022, it's not a simple matter to use Power BI to "Get data" if it is ArcGIS data or other data with a spatial column, and heaven forfend, we actually want to load that spatial column into a map visualization, join the table it's in to other tables, and color boundaries by a value column and such.  It's tough.

By "data" I don't mean the canned polygons from a geocoding service.  I mean "our data that we need to use for our business purposes."  And I'm mostly talking about polygon geometry here.

After engaging in a 5-day crash course in learning "Almost All the Maps for Power BI" to support a gang of customers, it dawns on me that maybe one of the first ideas for "ArcGIS Maps for Power BI" or "ArcGIS for Power BI" should be right at "Get data", where it all starts for Power BI users.  If I search for "ArcGIS", "Esri", "spatial", "location", or any key words of Esri's choice, I would expect to get a pick list along the lines of:

  • Map service
  • File geodatabase
  • Enterprise geodatabase
  • Shapefile (yes, even 30 years later.  or no, I personally don't really care to use shapefiles ever again, but my customers seem to love them.)

TimMinter_0-1665616084229.png

It looks like all the pieces are lurking around somewhere in my findings...

Whew.  There are so many constraints in that workflow, that it's essentially unusable for my purposes - confidential data; no external access to my ArcGIS Enterprise deployment (i.e. no Power Automate at present); leaping the fresh paywall; and why only ArcGIS Online hosted feature layers?  I can squeeze the necessary "EsriJSON" out of referenced map image layers, referenced feature layers, in ArcGIS Enterprise ArcGIS Servers federated with portal and stand-alone.

That little "convert to CSV file" piece appears to be the magic in the premium ArcGIS connector, so now it's on my list to go sniffing around GDAL again.  I mean, ETLing that EsriJSON geometry thing is my only missing piece at the moment in the non-automated, unpleasant workflow.  I've been doing GIS for some time now and have developed fortitude that most of the customers I support are too bright to develop.  They don't want to follow my "I will make it work" path.  They want, "It works!"  Right?  That's the thing.

TimMinter_3-1665618400002.png

Ok, that's it.  That's my idea.  Get data.

If the answer to this idea is, "no" because of technical constraints, strategery, or whatever, then how about an alternate idea?

  • Power BI > ArcGIS Maps for Power BI > wrench thing > search/find/add "reference layer"

TimMinter_1-1665617919128.png

  • Layers > ... > add "Add to Power BI" launcher that converts to CSV with geometry column so I can join and relate that with my other stuff, then get on back to the map and other visualizations.  Stick it right above "Remove" maybe?

TimMinter_2-1665618020998.png

 

tim

2 Comments
TimMinter

Actually, I like my alternate idea better because it re-uses all of the layers I've published in ArcGIS Enterprise and ArcGIS Online.  My Power BI customers can search/find/evaluate/get/use my data right there, and I can carry on with my ArcGIS and Tableau customers without further messing about.

Of course, this approach continues to break the basic Power BI user workflow.  Maybe we add "ArcGIS Online" and "ArcGIS Enterprise" to the "Get data" listing then search/find/etc.

RenePretorius

@TimMinter Great idea!

I would love to use Power Bi with our locally stored data (and yes we still use shapefiles on a daily basis, as well as file geodatabases), but trying to get the polygon data into Power Bi has just been too much of an effort and time drain to actually use it.