Forum Discussion
ArcGIS
I'm working with the visual ArcGIS and i dont undestand because it apperas the following error "Query has exceeded the available resources" when i add new column on "Size" or "Color" fields. Both belong to other table with relationship
I have filtered reducing the size of data but nothing change
Many thanks
Hi Alessandro70 ,
This error usually pops up when the ArcGIS visual in Power BI hits a resource limit — either due to data volume, complex relationships, or visual encoding (like using fields in Size or Color that require heavy aggregation or cross-filtering).
Here are a few things you can try to troubleshoot and optimize:
1. Cardinality & Relationships
If the fields you're using in Size or Color come from related tables, Power BI might be doing expensive joins behind the scenes. Try:
- Creating a flattened table using SUMMARIZECOLUMNS or SELECTCOLUMNS in Power BI to pre-join the data.
- Avoid using high-cardinality fields (like unique IDs or too many distinct values) in Size or Color.
2. Reduce Data Granularity
ArcGIS visuals are sensitive to the number of rendered points. Even if you filter the data, if the Size or Color fields introduce too many unique combinations, it can still overload the visual.
- Try binning or grouping your data before feeding it into the visual.
- Use aggregated measures instead of raw columns.
3. Optimize the Model
- Check if the tables involved have inactive relationships or bi-directional filters — these can cause performance issues.
- If possible, merge the tables in Power Query to simplify the model.
4. ArcGIS Visual Limits
ArcGIS for Power BI has internal limits (e.g. max number of features, rendering complexity). If you're hitting those, even a small change like adding a field to Color can push it over the edge.
You can also try testing the same visual with a smaller dataset or fewer fields to isolate the issue.
Let me know what kind of data you're mapping (points, polygons, etc.) and how large your dataset is — I can help you narrow it down further.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
3 Replies
- burakkaragoz
Super User
Hi Alessandro70 ,
This error usually pops up when the ArcGIS visual in Power BI hits a resource limit — either due to data volume, complex relationships, or visual encoding (like using fields in Size or Color that require heavy aggregation or cross-filtering).
Here are a few things you can try to troubleshoot and optimize:
1. Cardinality & Relationships
If the fields you're using in Size or Color come from related tables, Power BI might be doing expensive joins behind the scenes. Try:
- Creating a flattened table using SUMMARIZECOLUMNS or SELECTCOLUMNS in Power BI to pre-join the data.
- Avoid using high-cardinality fields (like unique IDs or too many distinct values) in Size or Color.
2. Reduce Data Granularity
ArcGIS visuals are sensitive to the number of rendered points. Even if you filter the data, if the Size or Color fields introduce too many unique combinations, it can still overload the visual.
- Try binning or grouping your data before feeding it into the visual.
- Use aggregated measures instead of raw columns.
3. Optimize the Model
- Check if the tables involved have inactive relationships or bi-directional filters — these can cause performance issues.
- If possible, merge the tables in Power Query to simplify the model.
4. ArcGIS Visual Limits
ArcGIS for Power BI has internal limits (e.g. max number of features, rendering complexity). If you're hitting those, even a small change like adding a field to Color can push it over the edge.
You can also try testing the same visual with a smaller dataset or fewer fields to isolate the issue.
Let me know what kind of data you're mapping (points, polygons, etc.) and how large your dataset is — I can help you narrow it down further.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes. Hi Alessandro70 ,
Thank you for reaching out to the Microsoft Fabric Community. , and I appreciate burakkaragoz for providing a clear explanation and helpful suggestions.
The error "Query has exceeded the available resources" in ArcGIS visual typically occurs when Power BI processes a large or complex query, especially if fields from related tables are included in the Size or Color sections. This often results in intensive background joins, increasing the visual's workload.
To address this, consider using DAX functions such as SUMMARIZECOLUMNS or SELECTCOLUMNS to create a new table that consolidates the necessary fields. This approach helps simplify relationships at runtime. Also, try to avoid using high-cardinality fields like unique IDs in the Size or Color sections, as these can significantly impact performance.
Even with filtered data, using fields with too many unique values in Size or Color can still cause ArcGIS to reach its limits. Grouping or bucketing data and using aggregate measures instead of raw columns can enhance performance.
Review your data model for any bi-directional or inactive relationships, as these may contribute to delays or overloads. Where feasible, merging related tables in Power Query can further streamline the model.
Please also note that ArcGIS visuals in Power BI have internal data limits, so even minor changes such as adding a new column to Size or Color can trigger this error if the dataset is near the threshold.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi Alessandro70 ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.
