Forum Discussion

VivekN's avatar
VivekN
Frequent Visitor
9 months ago
Solved

ArcGIS for Power BI – Embedded Report Losing Join Layers After Publish

I am experiencing an issue with ArcGIS for Power BI when embedding a published report. Here is the workflow I followed:

  1. In Power BI Desktop, I added the ArcGIS for Power BI visual and signed in using my organization credentials.
  2. 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.”
  3. 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
  4. I repeated this process to add five more join layers (total of six layers on top of the base layer).
  5. Under Settings, validation passed for embed and publish checks (all green).
  6. Published the report to Power BI Service – everything worked fine there.
  7. 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.

Need Help
Tips and Tricks
  • rohit1991's avatar
    rohit1991
    9 months ago

    Hii VivekN 

     

     ArcGIS provides a Web Map workflow which supports all layers  unlike the embedded ArcGIS for Power BI visual.

    1. Create your Web Map
      You can follow the official ArcGIS “Get started with maps” guide here:
      https://doc.arcgis.com/en/arcgis-online/reference/get-started-with-maps.htm 
    2. Share the Web Map
      Open the map >> click Share >> enable Everyone or Your Organization.
    3. Get the Embed Code
      On the Share page >> click Embed in Website >> choose size >> copy the iframe code.
    4. Use the iframe wherever needed
      Paste the iframe in your application/page to display the fully-layered ArcGIS map.
      This method keeps all your join layers intact because the map is rendered directly from ArcGIS Online instead of the ArcGIS for Power BI visual.

     

6 Replies

  • rohit1991's avatar
    rohit1991
    Icon for Super User rankSuper User
    9 months ago

    Hii VivekN 

     

    The embed link will always show the base layer + one join layer only. There is no Power BI setting to change this; the only workaround is to limit it to one join layer or publish the map directly from ArcGIS Online/Enterprise instead of using the embedded ArcGIS for Power BI visual.

    • VivekN's avatar
      VivekN
      Frequent Visitor
      9 months ago

      Hi rohit1991 

      Thank you for clarifying this limitation. Could you please guide me (or) point me towards documentation on the process of publishing the map directly from ArcGIS Online or ArcGIS Enterprise instead of using the embedded ArcGIS for Power BI visual?. Thanks. 

      • rohit1991's avatar
        rohit1991
        Icon for Super User rankSuper User
        9 months ago

        Hii VivekN 

         

         ArcGIS provides a Web Map workflow which supports all layers  unlike the embedded ArcGIS for Power BI visual.

        1. Create your Web Map
          You can follow the official ArcGIS “Get started with maps” guide here:
          https://doc.arcgis.com/en/arcgis-online/reference/get-started-with-maps.htm 
        2. Share the Web Map
          Open the map >> click Share >> enable Everyone or Your Organization.
        3. Get the Embed Code
          On the Share page >> click Embed in Website >> choose size >> copy the iframe code.
        4. Use the iframe wherever needed
          Paste the iframe in your application/page to display the fully-layered ArcGIS map.
          This method keeps all your join layers intact because the map is rendered directly from ArcGIS Online instead of the ArcGIS for Power BI visual.

         

  • v-venuppu's avatar
    v-venuppu
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi VivekN ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you rohit1991 for the prompt response.

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi VivekN ,

    May I ask if you have resolved this issue or any update on this? Please let us know if you have any further issues, we are happy to help.

    Thank you.