Dashboard reports not showing on published dashboard in SharePoint

Andrea Zenner

I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why.

I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing special about the two that show.

Anyone have any idea why?

Thanks in advance!

Paul Newcome

That is exactly it. Is the "Their Own Perspective" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct "perspective".

Paul Newcome

Are you able to share screenshots of how one that is working is set up on the dashboard and how one that is not working is set up to compare the differences?

Andrea Zenner

They are all report widgets. This is the one that is working:

This one is not working

The only difference I see in how the widgets are configured is that one is set to "last widget editor" and the other is set to "their own perspective" for viewer mode. Could that be it?

Andrea Zenner

That was it! When I change the widget behavior to last editor, it shows up.

Paul Newcome

That is exactly it. Is the "Their Own Perspective" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct "perspective".