Power Automate Connectors with ArcGIS Online and Power BI Integration

[JonJones1]

Hello everyone,

I'm new to Power Automate but frequently create AGOL (ArcGIS Online) maps as I'm the admin for my company's AGOL account. I also create dashboards for Power BI. Despite watching several YouTube tutorials, I'm still struggling with a few basic concepts. I'd greatly appreciate your help.

Here's my scenario:

1. AGOL Feature Layers:

   • I have a feature layer of endangered bird nests in a city, with each nest having a unique ID.
   • Another feature layer divides the city into inspection territories (a polygon layer), with each territory having its own unique identifier.

2. SharePoint/OneDrive Excel Files:

   • One Excel file contains data about the nests, correlating to the nest's unique ID.
   • Another Excel file contains information about the territories, correlating to the territory's unique ID.

My questions are:

1. Using Power Automate:

   • Can I set up connectors so that if I update either Excel file, my online AGOL map will update with the new information?

2. Power BI Integration:

   • If I select an item in a Power BI visual (e.g., a table), can it filter and highlight the corresponding item in my AGOL map within Power BI, enabling cross-filtering between visuals?

Thank you in advance for your assistance!

[JonJones1]

Just wanted to give an update in case anyone else has the same question. Based on a response in this thread, I found that the answer to my second question, "Can selecting an item in a Power BI visual filter and highlight the corresponding item in my AGOL map within Power BI?" is YES.

However, I'm still looking for insights on my first question: Will updating the Excel file automatically update the attributes of data in my AGOL map? Any thoughts?