Forum Discussion
Cross Join Issue in AAS Tabular Model
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
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 modelOr 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.
Best Regards
2 Replies
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 modelOr 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.
Best Regards
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