Public Google Data Connection, Model Tab not working as Expected

[StefanM]

Hey everyone!

This new model tab is throwing me through a loop, and im looking for some help.

I have a very simple mock timesheet on google that is publicly shared and correctly hooked up with PBI. However, the cross connection between tables is not working at all, not how it used to.

In the example file linked below, and looking at Page 3, the issue is clealry represented in a small table.

Only 1 agent has any Overtime logged, as seen in the linked spreadsheet. But its showing up on the PBI table for all three agents - which is telling me the relationship between the two tables is not working.

Do you guys have any ideas what went wrong here?

Spreadsheet: https://docs.google.com/spreadsheets/d/1C2ntDr5fipngyH29C1xTmjcCGsQmQaR6glpeYXP-QtE/edit?usp=sharing

Spreadsheet import link: https://docs.google.com/spreadsheets/d/1C2ntDr5fipngyH29C1xTmjcCGsQmQaR6glpeYXP-QtE/export?format=xl...

PBI File: https://mogi-my.sharepoint.com/:u:/g/personal/stefan_mucha_mogi-group_com/EXtC3Qf94qVFgGWEJUGP_TIBnV...

[StefanM]

Here is another way of looking at it - this is whats happening atm (note the red cells):



It seems as though the connection is working, because the data is filtered accross the two tables.

But its doing so incorrectly. Because its saying both agents have the Time-Off, when the input value only says 1 does.

[v-chuncz-msft]

@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/

[StefanM]

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... 😕