Table visualization error due to missing relationship

[Fern_21]

Hi all!

I need to display a table visual in Power BI with fields from the following tables: Tags, Models, and Spare Parts. If I add the Tags and Models fields or the Spare Parts and Models fields, it works, but as soon as I add all three Tags, Spare Parts, and Model it throws an error.

Keep in mind that I cannot directly link Tags with Spare Parts. The Spare Parts Models table is theoretically a bridge table between Tags and Spare Parts.

If I aggregate the spare_parts field in count/first/last, I can view it.

These are the relationships I have.

Thanks

[v-sathmakuri]

Hi @Fern_21 ,

I hope this information proves helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @Fern_21 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[rajendraongole1]

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.

[Fern_21]

Hi @rajendraongole1 !

Can I use this measure to correctly display the spare_part field within the table?

[rajendraongole1]

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.

[Fern_21]

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? 

[v-aatheeque]

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!

[v-sathmakuri]

Hi @Fern_21 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thanks!!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...