Forum Discussion
Table visualization error due to missing relationship
Hi Fern_21 - Since the tags table isn't directly related to spare_parts, create a measure to retrieve the associated spare parts. Use a Measure Instead of Direct Fields as like below
Eg:
Spare_Part_List =
VAR _SpareParts = CONCATENATEX(
RELATEDTABLE(spare_prts_models),
spare_parts_models[id_spare_part],
", "
)
RETURN _SpareParts
Hope this helps.
Hi rajendraongole1 !
Can I use this measure to correctly display the spare_part field within the table?
yes ofcourse, use it as per your shared snapshot. I have used table names. please check the table names and use it.
Let me know if it works, if not please share some sample data for reference by removing the sensitive data in your pbix file.
Hi rajendraongole1 !
I've inserted this measure, but now I get this error. "The visual has exceeded the available resources. Try filtering to decrease the amount of data displayed"
How can I solve it?Hi Fern_21 ,
It sounds like Power BI is struggling to handle the amount of data in your visual, which is why you're seeing that error. Here are a few things you can try to fix it:
- If your visual is displaying a lot of data, try adding more filters or slicers to reduce how much is shown. For example, limit the data to a specific time period or category.
- Instead of showing all the detailed data, consider using summary data. Aggregating values using functions like SUM or AVERAGE will reduce the load.
- If you’re using a complex DAX measure, it could be slowing things down. Simplify it if possible by avoiding unnecessary functions or using more efficient alternatives.
- Ensure your data model is clean and efficient. Remove any columns or tables you don’t need, and use summarized data where possible. Using a Star Schema instead of a flat table can also help.
- If you’re trying to show a large dataset, apply a Top N filter to only display the most important data. For example, you could show the top 1,000 sales records.
- Go to File → Options and Settings → Options → Query Reduction and enable options like “Reduce the number of queries” to optimize how Power BI handles data.
- If you’re using Power BI Premium and still hitting resource limits, you may need to scale up to a higher capacity for better performance.
Try these steps and see if the error goes away. Let me know if you'd like help with a specific measure or any further troubleshooting!
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.If you continue to face issues, feel free to reach out to us for further assistance!