Visual Not Loading When Using Hybrid Tables

[harsha_nalwad]

I have two tables, A and B, connected with a one-to-one relationship. I’m trying to create a visual using fields from both tables: A[col1] and B[col2].

Here are the scenarios I tested:

1. Scenario 1:
   Both tables A and B are in DirectQuery mode → The visual loads without any issues.

2. Scenario 2:
   Both tables A and B are in Hybrid mode → The visual does not load; it keeps refreshing indefinitely.

3. Scenario 3:
   Table A is Hybrid, and table B is DirectQuery → The visual does not load; it keeps refreshing indefinitely.

What is causing this problem and how do I resolve this ?
Note: Both of the tables are having 6000 records each and both of the tables are refreshed, table A has got the partitions after the refresh and table B has a direct query partition.

[MasonMA]

Hi;

I tested tables with 30,000 rows (one to one, Storage mode changed from DirectQuery to Dual) and the visuals load correctly. It looks the issue you experienced is not a simple deterministic storage-mode limitation. There’s likely something specific to your model, partitions, or environment that triggered it.

I'd suggest sharing more details about the setups, like partitioning details or visual configurations.. 

[v-kpoloju-msft]

Hi @harsha_nalwad,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @MasonMA,  for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member @MasonMA,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum