BLOG
|
@AW_Grove What about adding them to an AGO organization or to an AGE portal? Without knowing anything yet about how the upcoming connector for ArcGIS Enterprise works, my first solution idea (which might be discarded quickly) is: Add "make CSV for Power BI" to the tail end of our data update ETL procedures (ugh. so much ETL. Why can't an ArcGIS map service just cough it up?) Update the CSVs in portal and tickle the item dates as needed to communicate freshness accurately. Gah. Second solution idea... Koop idk, tim
... View more
02-03-2023
04:22 PM
|
0
|
0
|
3389
|
BLOG
|
Thanks for the detailed instructions @SeanKMcGinnis. Can I expect this to work with Power BI Desktop and our on-premises ArcGIS Enterprise deployment with no access from outside our organization's domain? All the documentation I've seen calls out "ArcGIS Online," so I'm expecting that I cannot use it with our ArcGIS Enterprise deployment.
... View more
01-17-2023
04:30 PM
|
0
|
0
|
3520
|
POST
|
@AnneTetley @RudolfdeMunnik - good info, thanks! I've tried making EsriJSON format files with FME's Data Interoperability extension for ArcGIS Pro and bounced off without success. Doesn't mean it doesn't work, just that I've not yet made it work or proven that it doesn't. I won't engage Esri support for this unless a boss shows up with a big stick and proclaims that it's ok if I don't proceed on other assignments for a while. Also, about all I know right now of Power Automate is that there is a space between "Power" and "Automate", which I suppose is the third step after my usual starting point of complete ignorance. My customers and I deal with confidential health and other information. I've inquired internally to discover if Power Automate is authorized for use with our data (i.e. does not transport or process our data outside of our domain and transports and processes our data within our domain in an approved and secure manner), and I'll proceed with trying the suggested approaches after that light goes green.
... View more
01-11-2023
08:14 AM
|
0
|
0
|
1670
|
IDEA
|
As-Is In ArcGIS Pro 2.9.5 (AGP), I can click a map containing numerous layers in the contents pane, then click Share > Web Layer > Publish Web Layer the "Share As Web Layer" dialog appears, and I can configure and publish I elect to "Copy all data * Feature" in order to create a "Feature Layer (hosted)" item type in ArcGIS Enterprise 10.9.1 (AGE) or ArcGIS Online (AGO), whatever AGP dutifully publishes the hosted feature layer to AGE. the AGE item page lists and links all of the layers in the item, one for each layer in the AGP map in order to share each layer as a separate item for AGE users to discover and use, I have to go to each layer item and click "Create View Layer" and go through that workflow to make separate item entries. ...and guess what - in AGE the title did not inherit the title of the layer, the item info/metadata is not present, Data tab just pulses Loading..., Visualization tab says "No legend" and zooms to the full extent of the web mercator basemap Idea for To-Be In ArcGIS Pro (AGP), I can click a map containing numerous layers in the contents pane, then click Share > Web Layer > Publish Web Layer the "Share As Web Layer" dialog appears, and I can configure and publish I elect to "Copy all data * Feature" in order to create a "Feature Layer (hosted)" item type in ArcGIS Enterprise (AGE) or ArcGIS Online (AGO), whatever New: I elect to "Create View Layers" for a) all; b) some; or c) none of the map layers AGP dutifully publishes the hosted feature layer and view layers to AGE. the AGE item page lists and links all of the layers in the item, one for each layer in the AGP map New: There is a "Feature Layer (hosted, view)" item for each map layer for which I elected to publish and create a view. New ...and each view layer inherits all of the item details, metadata, data & visualization styling from its source layer. Also, it works properly. I can then adjust the view layers as necessary, release them to my customers, and move to the next assignment. Bonus points The same pattern and capabilities hold for when I drag and drop a FGDB.zip onto the AGE "add stuff" thingy. And it works properly. Cheers, tim truncated tags ArcGIS, Pro, Enterprise, Online, copy, all, data, item, information, description, drag, drop
... View more
12-16-2022
10:55 AM
|
5
|
1
|
553
|
DOC
|
I kind of failed to mention that the more recent SQL Server instance is on new hardware, didn't I? So, yes, I would expect things to be even easier if you're upgrading in-place on your current hardware. No AD Alias (CNAME) changes needed. Check the SQL Server help for your version or with your DBA regarding when and how to backup when upgrading. My experience has been good and easy with backup/restore, so nothing really to report. tim
... View more
11-03-2022
08:00 AM
|
0
|
0
|
5936
|
POST
|
That's a good question. I'm not sure. If I recall, I think I registered the view with the geodatabase, which took forever, got it to work a little less slowly, handed it off to a workmate, and quietly slunk away. I'll keep an eye on Teams to see if my workmate starts grumbling on Tuesday morning, which is when supervised automation occurs for that particular data collection. All was quiet and successful this past Tuesday morn... hmm. Um. Well, we're at AGP 2.9.5, holding off on 3.x until some dust settles. Thanks for the report. We'll have a look after 3.1 releases. Also, this pattern with Esri's software has become known as "feature flicker" around our shop. A feature works properly at one release, then is borked at the subsequent release. Fairly annoying. tim
... View more
11-03-2022
07:55 AM
|
0
|
0
|
372
|
IDEA
|
Hi Frances, One of my teammates opened support case #03181219, which resulted in #BUG-000153360. From a quick scan, it looks like the bug fix recommendation and your info above about the accompanying DLL converged. I've had to move along to other assignments and have uninstalled Insights. Hopefully, my idea will come to fruition the next time I download and install it. Thank you, cheers, and have a proper weekend, tim
... View more
10-28-2022
02:58 PM
|
0
|
0
|
1438
|
IDEA
|
A few more data points... Found that the most recent MSSQL JDBC driver is 11.2. tried, failed. https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15 Noticed that I did not take a step to check or reset Classpath to the new driver. Looked around to see if I could do that. Probably not on my end in the role of "user." Maybe the Insights code goes sniffing and sets it automatically? idk. https://learn.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-ver15 SQL Server 2019 Enterprise instance Is Clustered = False SQL Server 2019 Enterprise security configuration: Force Encryption = Yes Certificate unexpired, issued by parent organization service account under which instance runs has read permission on certificate Hmm. Similar? "try removing this connection string property hostNameInCertificate=*.database.windows.net" from here https://github.com/microsoft/mssql-jdbc/issues/1926 gotta get back to work. tim
... View more
10-26-2022
09:59 AM
|
0
|
0
|
1513
|
IDEA
|
Hi Frances, This try failed with the same error message. 2022-10-25 07:52:11,914 [qtp1463877470-31] ERROR c.e.i.s.IntegratedSecurityLogin - IntegratedSecurityLogin failed: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Tag mismatch!". ClientConnectionId:<redacted guid-looking string> I have logging all the way up and can send you the log file. tim
... View more
10-25-2022
08:08 AM
|
0
|
0
|
1542
|
IDEA
|
Hi Frances, The account I'm using meets the ArcGIS Insights "Without data caching" permission requirements in the database, and I use that account to connect and use data without error or warning messages via all of the clients I initially mentioned. I've tried IP address and server name and CNAME (Alias) with fully qualified domain name in the Insights database connection dialog "Server name (Fully qualified domain name)" field. The insights_service.log shows a driver getting excited about a "Tag mismatch!" here: 2022-10-21 15:25:13,719 [qtp111819772-28] ERROR c.e.i.s.IntegratedSecurityLogin - IntegratedSecurityLogin failed: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Tag mismatch!". ClientConnectionId:<redacted guid-looking string>
... View more
10-21-2022
03:52 PM
|
0
|
0
|
1592
|
IDEA
|
Just an idea. I'm evaluating ArcGIS Insights Desktop 2022.2.0.4957 to add to our barrel of BI products. I installed it on my workhorse PC, Windows 10 Enterprise 21H2. I tried to connect to my solid, fully functional 10.9.1.2.9 enterprise geodatabase in SQL Server 2019 Enterprise. ArcGIS Insights Desktop didn't even get past the first thing I would wanted to do. SQL Server Management Studio, Power BI Desktop, Tableau, ArcGIS Pro, ArcGIS Enterprise, ArcMap, QGIS, Excel, etc. can do it, no problem. My idea is that ArcGIS Insights could do it, too. Fastest software evaluation I've ever done. tim
... View more
10-20-2022
02:15 PM
|
1
|
9
|
1667
|
IDEA
|
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.
... View more
10-12-2022
05:03 PM
|
0
|
0
|
1591
|
IDEA
|
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.) It looks like all the pieces are lurking around somewhere in my findings... Can add data from ArcGIS Online hosted feature layer via Power Automate Premium license using an ArcGIS connector to request “EsriJSON” from the hosted feature layer REST service and convert it to a CSV file that Power BI will load and which the ArcGIS Maps for Power BI visualization can render. 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. 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" 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? tim
... View more
10-12-2022
04:56 PM
|
6
|
2
|
1593
|
IDEA
|
Yes, need "easy button" for adding primary data tables that include geospatial geometry columns to Power BI, much like Tableau, ArcGIS Pro, QGIS, and other geospatially capable software can do. I would love it if Esri can make this happen via the "ArcGIS Maps for Power BI" visualization thingy. There is a hint in the "ArcGIS for Power BI" documentation (https://doc.arcgis.com/en/power-bi/get-started/prepare-your-data.htm) that "EsriJSON" might be a way to do this, but I have yet to find any workable details on how to do it. Everything I've tried so far over the last several days results in, "Oh, nuh-uh," including @EricO_Neal1 's example above. I realize that Power BI does not understand SQL Server Spatial (weird, right?), so I'm hoping that Esri can provide a way to keep the data together, including coordinates. Is it really EsriJSON as the help suggests? If yes (-ish, I realize there are constraints), then how?
... View more
10-11-2022
09:40 AM
|
0
|
0
|
1701
|
POST
|
Yep, me too. I need to use an off-menu feature class of an organization's administrative boundaries that are not in the list of recognized boundary types that the geocoders can find and supply. I can query the hosted map service in ArcGIS online and return EsriJSON in WGS84 with all fields like this: https://services2.arcgis.com/WW3T8U6q5EkZ9U3n/arcgis/rest/services/DCYF_Service_Areas/FeatureServer/1/query?where=1=1&outFields=*&outSR=4326&geometryPrecision=5&f=json note that returnGeometry=true is the default, so no need to specify I'll note that there is no such thing as a "Shape" column in that EsriJSON above, so I'm guessing that the help documentation is referring to what Power BI perceives as the Column1.attribute.geometry column. I can tell Power BI to load JSON, then get Power Query Editor to convert it to a table thingy from which I can load that Column1.attribute.geometry (or "Shape" when I rename it) into the Location well for an "ArcGIS Maps for Power BI" visualization, which then erases the basemap, creates a white canvas, and tells me "The accuracy of your locations can be improved (hint - not by any existing Power BI map visualizations, they can't) and presents a "Go to Location Type and learn more." button. I click the button and fill out this thing, which does not seem to understand what's happening: Clicking that "OK" button results in a briefly spinning spinner. Any pointers on how to get Power BI to use an EsriJSON file (or any approach, really) for using off-menu boundaries and columns like what one would find in a SQL Server enterprise geodatabase feature class that Tableau or ArcGIS can use (i.e. WGS84, SQL Server geography spatial type) would be greatly appreciated. I'm adding this little movie that I made to show the situation and provide the trickery necessary to get EsriJSON into Power BI as a data resource.
... View more
10-10-2022
04:35 PM
|
1
|
0
|
2588
|
Title | Kudos | Posted |
---|---|---|
1 | 02-07-2024 09:16 AM | |
1 | 02-07-2024 08:11 AM | |
1 | 01-18-2024 10:46 AM | |
1 | 01-05-2021 08:06 AM | |
1 | 10-31-2023 08:03 AM |