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.
Hi @suhayb1994 ,
Could you please share the number of tables and coulmn structure? because that PBIX file requires GA account login.
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?
Hi @suhayb1994 ,
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.
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.
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!
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:
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates