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 guys,
I am trying to create relational model (star schema) in the power bi backend but some of the figures i am getting doesnt make sense. In my appendix table i have a raw data table and in particular i have a Video Views (3sec) and Video Views (10sec) column which are not showing unique values by day. I think i have created a relational model which is wrong.
Can someone help me in solving this issue? I have attached the power bi doc below for reference which has the relational table i have already built.
Thanks,
Suhayb
Hi @Anonymous ,
Could you please share the number of tables and coulmn structure? because that PBIX file requires GA account login.
Thanks!
Hi,
Many thanks for your reply. I currently have 5 tables, in terms of column structure what do you mean?
I have attached a screenshot of my relational model view (hope that will help). Is there anything i can do on my end to give you access to the actual pbix file?
Thanks,
Suhayb
Hi @Anonymous ,
Yeah that screen shot helped. Can you please mentioned which type of relationship (one to many/many to many/many to one) you have selected for this star schema?
Hi @Tahreem24 ,
They all seem to be set to many to many relationships but i believe thats incorrect (it doesn't let me change the relationships to anything else). I have connected the ad_id fields from each table but unsure if this is the right thing to do.
Thanks,
Suhayb
Hi @Anonymous,
This is what i was expecting i.e. many to many relation is not a recommended.
It does force you to use M to M relationship because of some of the below reasons:
1. It may have duplicate records in ad-id column.
2. some records are matching with the your dimention tables.
If possible so please create some sample of excel file for all your 4 main dimention table so that i can duplicate this scenario at my end.
Thanks,
Hi @Tahreem24 ,
Thanks for your input. I have attached my sample excel files of my main tables which are needed. Please send me your mock up once done. Appreciate the help!
Thanks,
Suhayb
Hi @Anonymous,
I tried alot but not able to find any column key which has unique record/values across all 4 tables.
One alternative you can do is to append all 4 tables into one table using Query editor option.Follw the below ste for append query:
Step 1: Load all 4 csv files.
Step 2: Go to Edit Queries option -->Home --> Select any table(csv) for example (FB_videos) -->select Append Queries --> Choose 3 or more table option --> and one by one add all remaing 3 csv --> click ok.
Step 3: Save and close.
Step 4: Check your values.
So, you don't need to create relationship between 4 tables as there are no unique records between them.
Please give KUDOS and Accept this as a SOLUTION if it helps you!
Thanks,
Hi @Anonymous,
Please see the below screen shot. After applying append queries step FB_Videos becomes my master table which contain other remaining 3 table's data also so I hide all these 3 table(csv) as you can see in below screen shot:
Thanks!
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |