ArcGIS for Power BI Blog

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Other Boards in This Place

Latest Activity

(16 Posts)
NaZhang_Esri
Esri Contributor

Hope everyone enjoyed the Esri User conference this year! We heard a lot of feedback from you and hope to make some great changes to the component. This blog lists the frequently asked questions during the 2023 Esri UC. If you missed out the UC this year, don’t worry about it. Here comes the answers!

2023-08-18_10-29-06.png

 

Read more...

more
3 0 1,046
NaZhang_Esri
Esri Contributor

Hope everyone is enjoying the summertime and here comes our hot ArcGIS for Power BI new release. Did you attend the 2023 User Conference in San Diego? It was awesome!

giphy

Read more...

more
3 1 1,057
NaZhang_Esri
Esri Contributor

It’s spring! Hope everyone is enjoying some flower blossoms. During this beautiful time, here comes our first ArcGIS for Power BI release in 2023.

Picture1.gif

Read more...

more
4 0 1,014
AnthonyLatini
Esri Contributor

It's the most wonderful time of the year! Cozy slippers, warm sweaters, snow (in some parts of the world), and another update in ArcGIS for Power BI. 

AnthonyLatini_0-1671234089415.png

 

Read more...

more
4 0 562
AnthonyLatini
Esri Contributor

Ah summer is here! Which means going to the beach, attending parties, staying cool, and of course, squashing bugs and enhancing features in ArcGIS for Power BI. Oh and I think the Esri User Conference is coming up! 

Esri User Conference Info: Esri User Conference: July 11–15, 2022

 

AnthonyLatini_0-1655348781716.png

 

Read more...

more
4 0 1,103
AnthonyLatini
Esri Contributor

Another release already? Seems just like yesterday that we had a release in ArcGIS for Power BI. Take a look at the work we've done in our second release of 2022!

AnthonyLatini_0-1649285234090.png

 

Read more...

more
2 7 5,868
AnthonyLatini
Esri Contributor

Whoever said that bugs were actually a feature?

Check out some of the fixes and updates we made in ArcGIS for Power BI to kick off the 2022 year! 

 

AnthonyLatini_0-1644343323316.png

 

Read more...

more
2 18 1,977
MrinmayeeBharadwaj
Esri Regular Contributor

2021 was a BIG year for the ArcGIS for Microsoft 365 team here at Esri!

Read more...

more
0 0 329
SeanKMcGinnis
Esri Contributor

As organizations look to improve efficiencies by leveraging robotic process automations, many are adopting Microsoft’s Power Automate to support their automated workflows and data pipelines. We have started building the ArcGIS Connectors for Power Automate to help extend the Flows to leverage your geospatial content.

The biggest consideration to be aware of when starting to build Flows in Power Automate using the ArcGIS Connectors is record count. Record count is important for a few reasons:

  • HTTP request time limits in Flows
  • Maximum of 5000 iterations the ‘Do until’ control can handle
  • Getting consistent results

Power Automate has HTTP request limits and timeouts for connector operations that take longer than two minutes. Geospatial can have thousands of records and when working with complex geometry, the size of the data grows, and processing can take a while.  To prevent the connectors from timing out, the ArcGIS and ArcGIS PaaS  connectors have been built with 150 record count limits to help prevent timeouts from occurring.

As we know, many datasets we work with have more than 150 features, but the ‘Do until’ control allows us to iterate through the data in 150 record chunks.

There are a few steps to getting the ‘Do until’ control set up to step through your dataset:

  1. Initialize a variable to track the offset as the Flow iterates through the records
  2. Wrap the logic for each record in a ‘Do until’ control
  3. Update the offset variable with the current offset of the record you are working with

PA_DoUntil.png

This pattern will allow the flow to iterate through the records with less concern of the control timing out.

For those new to programming concepts, below are a few resources to provide some additional understanding:

One thing to be aware of, the ‘Do until’ control does have a maximum number of iterations that it will run. By default, the control is set to run 60 times. The count is configurable and can be set to run a maximum of 5000 times. For other configuration options and design considerations, check Microsoft’s documentation.

Finally, record count is an important consideration for consistent of results. In our testing, we have seen discrepancies in the result counts when working with large datasets and have found working with data that is 5000 records or less has much more consistent results.

To summarize:

  • Record count and data size is a VERY important consideration when building your Flows in Power Automate.
  • Use the ‘Do until’ control to facilitate the iteration through the individual records.
  • Configure the ‘Do until’ count limit to support the number of records you expect to work with each time the Flow is run.

more
0 3 2,271
ScottBall
Esri Regular Contributor

We've received a number of questions regarding how and when Power BI data is sent to Esri when Power BI users interact with the ArcGIS Maps for Power BI visual. I'd like to share these answers with the community so everyone is aware of when their data is - and isn't being sent to Esri for geoprocessing. 

Q: There are data going to and from the ArcGIS site.  I am assuming this is just address data for mapping purposes only. The question is what data is sent between Power BI and ArcGIS? And is this data being stored by ArcGIS?

A: Correct, only the data needed to geocode the address (ie, fields placed in the Location field well) are passed to Esri servers. These data are only used to generate the information used to place the locations on the map and they are not stored by Esri servers.

Q: Does ArcGIS offer a service where this data is not collected for internal use or shared with any partners?

A: As mentioned, we do not store this data. We also do not share it with partners. If data being passed to Esri is a concern, you can use the latitude and longitude field wells to map their point data instead of using the Location field well. When using the latitude and longitude field wells, no data is passed to Esri for mapping – but it does require you to have performed the geocoding process some other way.

Q: Does ArcGIS maps geo-coding have a limit on the number of waypoints that can be sent?  If so, what is the limit?  Is there a limit per day?

A: Limits to geocoding are on a per-map basis and can be found in our documentation here.

Q: Is it possible our address list or search history is never shared for marketing purposes to any partner of ArcGIS?

A: Address list and search history information from ArcGIS Maps for Power BI is never shared for any purpose to any partner of Esri.

more
3 4 4,234
106 Subscribers