Custom Power BI Visual Performance Issue with Measure Values and Multi-Table Relationships

[KumbharM]

Hello,

We are currently developing a custom visual in Power BI. The visual contains a data field used for applying colors to datapoints. Previously, this field supported only categorical values, where different colors were assigned to datapoints based on their respective categories.

As part of a new requirement, we added support for measure values as well. The visual now works correctly with measure values under normal conditions.

However, we are facing an issue when relationships are created between two tables. If datapoints from both tables are used within the same visual and coloring is applied using measure values, the visual throws the following error:

"Query has exceeded the available resources."

If the relationship between the tables is removed and the visual contains datapoints from only a single table, the visual works correctly without any issues.

Could someone please help us understand why this is happening and suggest possible solutions or best practices to handle this scenario?

Thank you.

[tharunkumarRTK]

@KumbharM 

is it happening even with builtin visuals? for example table visual?

If yes then I dont think it has anything to do with your custom visual code. 

I would suggest you to remove the query simulation limits in your power bi desktop. refer the below page for more info 

Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn

Then using performance analyzer and DAX studio to check where exactly the query is breaching the limits either the memory limit or the time out limit. Accordingly try to optimize your DAX code or visual elements 

Connect on LinkedIn

read my blogs here: TechieTips

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!