Creating a table viz with columns from 4 tables

[klehar]

Hi,

I have a star schema model that has 4 tables.

But since I want all the columns from all the 4 tables in a single table, I have made the relationship type to be bi directional.

I suspect that is causing a cross join between all the tables.

This is causing a memory issue and the table is unable to load.

Has anyone encountered such a scenario?

Model Representation:

Looking at the dax studio query I do find something fishy(link)

How to overcome this and still use the table visual?

[v-jingzhang]

Hi @klehar 

It's not a proper star schema model. In a typical star schema model, the Fact table should be in the heart of a star and Dim tables are around Fact table as points of the star. Usually the relationships between Fact table and Dim tables are one-to-many with Fact table at the many side and Dim tables at the one side. 

In your model, the table [Standard/SWIFT Orders] in the heart is at one side of all relationships with other tables. When you use columns from 4 tables into a table visual, there will be a lot of matching combinations and some combinations may not be correct or meaningful. Consider if this model design is appropriate to get your expected result. You may need to modify it. 

Here are some helpful resources:

Power BI Basics of Modeling: Star Schema and How to Build it - RADACAD

Power BI Tips for Star Schema and Dimensional Data Modeling

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

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.