Unknown Workspace In Report. Not Showing all Data

So we have a manager here who builds reports for his employees and shares those reports. However, we ran into a peculiar issue yesterday. One of the employees reports stopped showing all data. So the manager shared the report with me (I am admin and owner of all sheets on the report) When I click the report, absolutely no data is being reported.

When I rebuild the report on my end I can see all the necessary data but the user still has missing data. But what is really curious is that when the manager builds or makes changes to the report all data for me disappears. The only thing I have noticed is that under the Where? section of the report where you specify what sheets you want data from, for me and the user it says "Unknown Workspace" But for the manager it shows all the sheets he added.

So....what's the deal here?

Find more posts tagged with

Reports

IT & Operations

Comments

Brett Evans

Have you tried having the manager deleting your access to the workspace, then loggin out having the mgr reassign acess and then logging back in?

Just spitballing here because I have never seen that, but that is what I woudl try first.

Tim Meeks

Was the Workspace name changed since the report was created?

Columns or sheets will do this if their name is changed after being associated with a report.

Shawn R

Well, I can't really. Some of the sheets the report is pulling from are created by me and I am the owner. This is what is really strange about this. It doesn't seem to be an issue with the sheets but rather with the report. Just to clarify, the sheets the report it pulling from consists of approximately 15 sheets. At least 4 of those sheets I am the owner of, the rest are split between the two other users we have in our account.

The manger in this case is the one who created the report. The manager is also the only one who sees the report correctly. The user the report is created for only sees some data (missing about half) Me, who the report was shared with today literally sees nothing.

If I edit the report myself and reset the (Where?) column I see everything, but the user the report is created for still only sees half and the manager who created the report sees everything. Once the manager who created the report makes any sort of change to the report, I go back to seeing no data but the user who the report was created for doesn't change. (still missing half the data)

I could ask the manager to delete the report and start over, but after some investigation it seems that multiple reports he created for other users are experiencing the same issue. Which tells me its an error by the report creator or some permissions issue with sheets.

So I am kind of at a standstill until I can figure out what is causing the missing data (which was allegedly there yesterday)

Shawn R

Tim, no workspace name has been changed to my knowledge, but I will ask the other two users who create sheets and get back to you.

Shawn R

This is fixed. Wasn't naming but a permissions issue, which I don't fully understand. But thats OK. Just glad its working.