Forum Discussion
Helper IIIPowerbi modelling 1-->*
Hello,
I'd like to separate my tables to be more efficient in powerbi.
I used google analytics connector with the following data
I'd like to link campaigns-name/Campaign with objecfifs/Campaign and Campagnes/Campaign tables with 1-->*
I'd like that campagnes table and objectifs can communicate with campaingn segment
I create campaigns-name in powerquery
1- i dupplicate Campagnes table (new table campaigns-name)
2- remove all columns except Campaign
3- remove all dupplicate content in Campaign column
When I try to link campaigns-name/Campaign with objectifs/Campaign I can't have 1-->* relationship
In powerquery :
How can i do have this type of relationship ?
A response would be appreciated
Noliverte
noliverte you should set a relationship the similar way you set it with Calendar table. Not sure what is the exact question? Do you get any error or run into an issue when you try to connect this new unique campaign table with other tables?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
I just find an solution... My campain's column hadn't unique values... When I applied delete dupplicate in all my campain column, I always had dupplicate fields... I had to apply a low case filter and it's work !!!
Bye
Noliverte
3 Replies
- parry2k
Super User
noliverte you should set a relationship the similar way you set it with Calendar table. Not sure what is the exact question? Do you get any error or run into an issue when you try to connect this new unique campaign table with other tables?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
noliverteI just find an solution... My campain's column hadn't unique values... When I applied delete dupplicate in all my campain column, I always had dupplicate fields... I had to apply a low case filter and it's work !!!
Bye
Noliverte