ARC-GIS PowerBI Help!

[buddycho]

I am trying to make a battery industry market map using ARC-GIS in PowerBI. I have two data sets (individual sheets in one Excel file). One has manufacturing facilities (lat,long) and the other has critical mineral deposits (lat, long). I was each of these to function as a layer on my map. I also want to have filters/slicers on the dashboard page. For example, I should be able to filter for "Cell Manufacturing" and only have that impact the Facilities layer and I should be able to filter for "Lithium"and only have that impact the critical minerals deposit layer. I do not need cross filtering. I just want to have both layers (and to be able to add/remove at will) on a single map. I also want to have corresponding tabels on the dashboard page. Appending and join layer do not seem to work. I cannot use PowerBI filters/slicers on a feature layer loaded from PowerBI. I also need help ordering the Tooltips fields. They don't stay in the order I have them on the visual pane. Any help is appreciated! 

[Ahmed-Elfeel]

Hi @buddycho,

You can not use the standard Power BI Fields pane for ArcGIS layers if you want independent filtering (You must use the maps own layer menu)

In Short:

1-Adding Data to Map Layers:

• Click on your ArcGIS map visual.
• In the map toolbar click the first icon (Visualizations pane for the map).
• Click + Add Data > Power BI Dataset.
• (For Layer 1) Select your Facilities table then Set the latitude/longitude then Drag Type to "Category"
• (For Layer 2) Click + Add Data again and Select your MineralDeposits table then Set the latitude/longitude then Drag Mineral to "Category"

2-Slicers Fix:

• Create your slicers from the Facilities(Type) and MineralDeposits(Mineral) fields.
• The Secret part is that is the layers will automatically respond only to slicers from their own source table no special interaction settings are needed for the map (The Facilities layer ignores the Mineral slicer and vice versa)

3-Fix Tooltips:

• In the ArcGIS visual settings then go to each layer's Tooltips section.
• Manually drag and drop the fields into your desired order ( Ignore the order in the Power BI "Fields" pane)

Note:

• By adding layers via PowerBI Dataset you are connecting the ArcGIS visual directly to the Power BI data model allowing it to respect the native filtering context from slicers on the page
• The tooltip ordering still needs to be done manually in the ArcGIS layer settings but the core filtering problem will be solved

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

[buddycho]

I am stuck here 

• Click + Add Data > Power BI Dataset.

I do not see an option to add the PowerBI data

[v-menakakota]

Hi @buddycho ,

Did get a chance to view the document, can you please confirm whether the issue got resolved.

Thank you.

[v-menakakota]

Hi @buddycho ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank   @Ahmed-Elfeel , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[v-bmanikante]

Hello @buddycho 

I am also part of CST Team and we’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Regards,

B Manikanteswara Reddy

[buddycho]

I am stuck here 

• Click + Add Data > Power BI Dataset.

I do not see an option to add the PowerBI data

[v-bmanikante · Accepted solution]

Hi @buddycho,

Thanks for your update. Based on your scenario, I believe the following Microsoft Learn documentation could be helpful.

Create an ArcGIS map in Power BI - Power BI | Microsoft Learn

Please review it and let us know if you need further guidance.

Best regards,

B Manikanteswara Reddy