Forum Discussion
Public Google Data Connection, Model Tab not working as Expected
StefanM ,
The requirement is not very clear, but you may try to apply virtual relationship in DAX measure.
https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
- StefanM7 years ago
Helper II
Hey! Thanks for the response and sorry for the confusion.
This is what it should appear as in PBI based on the data input:
I could get this working on the old build, but now, it just wont connect in the same way. This is what I am getting instead:
Blue = individual core data + measures. All working
Red = all measures mixed together, not working.
Here is another image highlighting one of the issues more directly:As you can see... the data is spread out to all agents. Not just E, as the original data set indicates.
This issue is in place for each table. The data connection is simply not working at all :/ And I have no idea why! lol
Can anyone help me to unscramble this situation - what could be going wrong? Afaik, ive setup the connection like I have hundreds of others. The measures are all correct too, otherwise they wouldnt be working in the first instance (in blue). IM just so completely stumped by this one... :/