Select to view content in your preferred language

Filter an AGOL layer with information in Power BI

465
1
08-23-2023 07:49 AM
Labels (3)
Diego_Mendes_Rodrigues
Emerging Contributor

Good morning,

I have a dashboard in Power BI, using ArcGIS for Power BI, with:

+ Data:
  - Imported from 1 Excel spreadsheet (Equipamentos_Publicos / public_equipment)

+ Map (ArcGIS for Power BI):
  - Layer with Excel data (Coordinates / equipamentos_publicos / public_equipment)
  - Layer with data from an AGOL feature layer (Equipamentos Públicos / Public Equipment)

ArcGIS for Power BI - 01.png

 

How can I filter the data layer of AGOL (Equipamentos Públicos / Public Equipment), through the 'Categorias' (Categories) field that is in the data layer (public_equipment) of Excel?

ArcGIS for Power BI - 02.png

Thank's a lot!

Diego

0 Kudos
1 Reply
LeslieUK
Esri Contributor

Hi @Diego_Mendes_Rodrigues 

I think what you are looking for is to join the data layers from Power BI with the Data from ArcGIS Online. IN which case this documentation will guide you through how to do this: Join layers—ArcGIS for Microsoft 365 | Documentation

~Just trying to fix things~
0 Kudos