I am experiencing an issue with ArcGIS for Power BI when embedding a published report. Here is the workflow I followed:
- In Power BI Desktop, I added the ArcGIS for Power BI visual and signed in using my organization credentials.
- For the base layer:
- Added GeometryEsriJson to Location
- Added LocalAuthorityDistrictName (text) to Tooltips
- Added LocalAuthorityDistrictID (text) to Join Layer
- Applied a visual-level filter for “West Midlands.”
- Next, I created join layers to enable interaction between ArcGIS and Power BI data:
- Navigated to Layers → ArcGIS Data → My Organization and uploaded a feature layer from our ArcGIS Enterprise portal.
- In Analysis → Join Layer, I set:
- Target layer: Current feature layer
- Join fields: LocalAuthorityDistrictID (Power BI) ↔ LocalAuthorityDistrictID (Feature layer)
- Join operation: First row only
- Fields to append: LocalAuthorityDistrictID
- Interaction behavior: Filter
- I repeated this process to add five more join layers (total of six layers on top of the base layer).
- Under Settings, validation passed for embed and publish checks (all green).
- Published the report to Power BI Service – everything worked fine there.
- However, when I generated an embed code and opened the report via the embed link, only the base layer and one join layer appear. The other five join layers are missing.
I tried recreating the map in both Power BI Desktop and Service multiple times, but the issue persists.
Environment details:
- Power BI Desktop (latest version)
- ArcGIS for Power BI visual (latest version)
- ArcGIS Enterprise license
Question:
Why do the join layers disappear when the report is accessed via the embed link? Is this a limitation of ArcGIS for Power BI in embedded scenarios, or is there a configuration I’m missing? Any guidance or workaround would be greatly appreciated.
