Forum Discussion
Solved
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 retai...
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 ,
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
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.
Best Regards