Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PBIRS Composite Model Other Recommendation

Hi all,

 

Using PBIRS - Sept, 2021.

I tried creting a Composite Model for M:M relationship between by Shipping Table and my Parts_Bom Table.
Cannot do that in PBIRS, at least as of Sept, 2021.

I also tried creating a Bridge Table with bi-directional cross-filtering from the Bridge Table to both Fact Tables
I am still getting the dreaded "Can't display the visual" on my Matrix which has the Module from the Shipping Table (Fact) and the Parts from the Bom Table (Fact)

 

1.) Are there other versions beyond Sept, 2021 that support Composite Models for PBIRS?
2.) Are there other Modeling ideas I have not tried to be able to bring the required fields from the various tables into the Matrix?

Thanks,
-w

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    There are a few limitations for this release of relationships with a many-to-many cardinality and composite models.

    The following Live Connect (multidimensional) sources can't be used with composite models:

    • SAP HANA
    • SAP Business Warehouse
    • SQL Server Analysis Services
    • Power BI datasets
    • Azure Analysis Services

    When you connect to these multidimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with imported data.

    The existing limitations of using DirectQuery still apply when you use relationships with a many-to-many cardinality. Many limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an imported table can refer to other tables, but a calculated column on a DirectQuery table can still refer only to columns on the same table. Other limitations apply to the whole model if any tables within the model are DirectQuery. For example, the QuickInsights and Q&A features are unavailable on a model if any table within it has a storage mode of DirectQuery.

     

    Best Regards,
    Community Support Team _ Caitlyn

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