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 Community,
I am trying to link our accounts in CRM to website activity in Google Analytics (GA) by using both service providers and network domains (fields in GA). I have pulled tables for our Accounts in CRM, Network Domains in GA, Service Providers in GA, and web page statistics. When I try to activate the relationship between Network and All Website Data, I get the message "You can't create a direct active relationship between ... because that would introduce ambiguity between accounts and All Website Data. ..."
I was thinking of creating a combined primary key consisting of Network Domain and Service Provider, but some Accounts have varying numbers of Network domains and Service Providers and some that have Network Domains but no service providers.
Ultimately I'd like to have a report that allows me to select a sales rep, show their accounts and then drill down into the website activity regardless of the Network Domain or Service Provider.
Thank you.
Solved! Go to Solution.
Thank you, @Lind25. I'm sure this will eventually work. However, once I tried to join the tables I ran into another a problem relating them to each other because there were no unique entries in one table.
Now I am having issues connecting to GA because I exceeded the daily limit, so this project is on hold at the moment.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |