Forum Discussion

StefanM's avatar
StefanM
Helper II
7 years ago

Public Google Data Connection, Model Tab not working as Expected

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=xlsx

PBI File: https://mogi-my.sharepoint.com/:u:/g/personal/stefan_mucha_mogi-group_com/EXtC3Qf94qVFgGWEJUGP_TIBnVJJpNs2InCvZRFNHFT0Pg?e=hcE5ww

Need Help
Tutorial Requests

3 Replies

    • StefanM's avatar
      StefanM
      Helper II
      7 years ago

      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... :/

  • StefanM's avatar
    StefanM
    Helper II
    7 years ago

    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.