Dashboard reports not showing on published dashboard in SharePoint
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!
Best Answer
-
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".
Answers
-
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?
-
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?
-
That was it! When I change the widget behavior to last editor, it shows up.
-
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".
