topic Cross Join Issue in AAS Tabular Model in Developer

Cross Join Issue in AAS Tabular Model

nottyheadedboss — Wed, 12 Oct 2022 00:28:44 GMT

I am a newbie to the world of AAS and using the same as a source in Power Bi. I have multiple tables, a couple of dimension tables and one fact table.

The fact table has 2 keys retailerkey and retailerproductkey. The dimension tables retailerdim has retailerkey (PK) and retailerproductkey (FK). The other dimension table is retailerproductdim and has the retailerproductkey (PK) and retailerkey (FK) and a few other details related to the products sold by the retailer such as SKUID and SKUname...

The relationship is as below

Retailerdim.retailerkey to salesfact.retailerkey AND

retailerproductdim.retailerproductkey with salesfact.retailerproductkey

There are a couple of other dimension tables with their respective dimension keys and each of these keys are present in the salesfact table.

The seller key in the seller table is mapped to the seller key in the salesfact table. The category key in the category table is mapped to the category key in the salesfact table.

Now when I extract this name colums from the respective dimension tables into the powerBI report, I end up getting across join where for a single sku name, I either get multiple brands or

Multiple categories map to the same SKU name.

Is there a process by which I can avoid this cross join within AAS

Thanks

Re: Cross Join Issue in AAS Tabular Model

Anonymous — Wed, 12 Oct 2022 07:50:17 GMT

Hi @nottyheadedboss ,

The problem seems to be caused by these created relationships... You can refer the following links to try to solve the problem...

Duplicates on table due to relationship model

Relationships in Power BI

Or you can provide the following info, later we will make troubleshooting and check if can give you a solution....

Which connection mode you are using when you connect to AAS in Power BI Desktop?
The screenshot of the relationships created among the tables
Some sample data(exclude sensitive data) in the tables. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community

Best Regards

Re: Cross Join Issue in AAS Tabular Model

Anonymous — Wed, 19 Oct 2022 01:44:42 GMT

Hi @nottyheadedboss ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards