Visual Not Loading When Using Hybrid Tables

Hi harsha_nalwad,

Thanks for explaining the scenarios clearly. In addition to the solution shared by the community member MasonMA, below, here’s an alternative approach you can consider.

Since the visual works when both tables are Direct Query, the issue isn’t data size or the 1:1 relationship itself. The problem occurs when Hybrid tables are involved. In a Hybrid + Direct Query setup, Power BI decides at query time whether to use Import mode or Direct Query mode. When one table contains imported partitions and the related table is Direct Query-only, Power BI can repeatedly switch execution paths, causing a query planning loop which is why the visual keeps refreshing indefinitely.

To resolve this, align storage modes across the related tables (both Direct Query, or both Hybrid with consistent partitioning). If possible, avoid 1:1 relationship with Hybrid tables and prefer a star-schema (1:*), or merge the tables upstream. For small lookup tables, setting them to Dual can also help Power BI resolve joins in memory. These approaches follow Microsoft’s composite model best practices and should prevent the infinite refresh behaviour.

Refer this link:
1. https://learn.microsoft.com/en-gb/power-bi/transform-model/desktop-storage-mode 
2. https://learn.microsoft.com/en-gb/power-bi/guidance/composite-model-guidance 
3. https://learn.microsoft.com/en-gb/power-bi/transform-model/desktop-composite-models 

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.