Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, good afternoon,
I am very new in DataWareHouse, please can yo give me advice,
I have a fact table from a select where i have got two rows, one raw by any incident, which columns than identify the caseid and the productid which has produced the incident, one product has generated two incidents.
The problem is when i select a query than returns me by any incident the id of the email that the user sent to communicate the incident.
Of course i have my DimensionMail, which a primary key that is the id of the email and a column that is the email, of course is a varchar colum, buit i am a little confused with the results, i mean the number of rows in the 2 fact tables.
Please have a look at the squema, i thin is correct, buy i would like your opinions.
Thanks a lot
Hi @JavierM,
As above question is more related to DataWareHouse, you'd better contact with DataWareHouse support team to get more professional advice.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |