Improving report query performance

Hi,

Thanks for the solution rajendraongole1  offered. and i want to offer some more infotmation for user to refer to.

hello YoungLearning 

for the cardinality relationship,  the model won't provide flexibility in the ways you report visuals filter or group

And the connection mode is direct query mode, it has limitations for direct query mode, you can refer to the follwing link.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships#considerations-and-limitations

When we have two tables that have many-to-many relationship, we often create a bridge table to create a one-to-many relationship among them, you can refer to the following picture.

2.For the cross filter, the data mode is direct query,  then using bith filer direction, you can apply the filters by propagating the filter context to a second related table on the other side of a table relationship. you can refer to the following link.

Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn

And you can refer to the following link about the advantage of star schema.

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many#relate-many-to-many-facts-guidance

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.