Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Unable to create relationships between tables

Hello Everyone,

I am trying to create a data model from facebook ads data. I have 6 tables which i need linked together but have no idea how to do so. I have attached my power bi file for reference. Can someone please help? I have attached my dataset below:

Thanks,

Suhayb

v-diye-msft
6 years ago
Hi Anonymous

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

4 Replies

mussaenda
Community Champion
7 years ago
Hi Anonymous ,

For me, I suggest you to have a table for all unique account id and create a star schema.
I notice that your campaign table has no ad_name but their common denominator is account id

hope this helps.
- Anonymous
  Not applicable
  7 years ago
  Hi mussaenda
  
  Thanks for getting back in touch. When creating a star schema does the cross directional filter need to be set to 'both'?
  
  Regards,
  Suhayb
  - v-diye-msft
    Community Support
    7 years ago
    Hi Anonymous
    
    You can refer to the below blog to build a star schema:
    
    https://bigbearbi.wordpress.com/2015/09/12/building-a-star-schema-in-power-bi/
v-diye-msft
Community Support
6 years ago
Hi Anonymous

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!