Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you for your answer parry2k.
In fact when I try to link these 2 tables with the key campain with cardinality 1-->* I have the following error message
Sorry I have french version of Powerbi
How can i fix it ?
Do you have an idea ? Which type of test ?
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |