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. ...
Need Help
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.