Limited relationship icon appear in the semantic data model powebi live connection.

[Anonymous]

Hi Support ,

We have a powerbi report with live connetion,we are seeing the Limited relationship icons while setting a relation between( fact to dim ) tables,why is it showing like that even we did not change anything on that?does it cause any issues while filtering data the report.

please give more information on this which will helpful.

attaching screenshot of the issue for referenece.

Thanks.

[Anonymous · Accepted solution]

Hi,@Anonymous. I am glad to help you.
Hello, @Greg_Deckler ,thanks for your concern about this issue.

Your answer is excellent! And I would like to share some additional solutions below.
Did you get your problem solved, according to the screenshot you provided, the relationships between the tables in your model are all Limited relationships.
 

This situation usually indicates the existence of certain relationship restrictions, that is, there may be specific reports in the production of data results and the expected value does not match, in order to reduce the production process in the report this situation, you need to check whether the relationship is set correctly, the relationship between the direction of the screening needs to be modified, in the case of necessity in the DAX formula to use the USERELATIONSHIP function to clearly specify the relationship to be used to avoid problems!
Fortunately, I found some articles about limited relationship, hope it can help you!
URL:
What are the strange symbols in a Power BI relationship? All you have to know about weak or limited relationships - What the fact.bi

I also found other similar issues on the forum that have been resolved, so I hope you can benefit from them.
url:
Solved: The icons between tables in relationship - Microsoft Fabric Community
Solved: Unfamiliar icon on relationship lines in Model Vie... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[Anonymous]

Not a direct query mode,Its single source and SQL server Analytics Services as a database.

[Greg_Deckler]

@Anonymous When you say "live connection" do you mean DirectQuery? Is there a single DirectQuery source or multiple?