Filter an AGOL layer with information in Power BI

[Diego_Mendes_Rodrigues]

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)

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?

Thank's a lot!

Diego

[LeslieUK]

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