Connect two datasets (SharePoint file & Semantic Model) and show all info/ data

Hi Anonymous ,

Regarding your question, you should be working with a composite model, which is a limited relationship. When you create a table-to-table relationship, it performs an operation similar to an inner join, i.e. it only gets the intersection of the two tables.

Table expansion never occurs for limited relationships. Table joins are achieved by using semantics, and for this reason, blank virtual rows aren't added to compensate for referential integrity violations.

Please read the following documentation for more details(Limited relationship component).

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards