Workaround when a report I have on a dashboard has more than 500 rows

1845sarah

I have a published dashboard which all non-licensed Users can access to submit a request. This dashboard also shows a report with 'open' requests and 'closed' requests

The 'open' requests report is ok. It very rarely holds more than 50 rows

The 'closed' report is my issue as the maximum number of rows I can display is 500. When it goes above 500 rows, User see this:

When they click on the message they get this:

The sheet isnt deleted: its just not shared to the Users as I want to publish it to restrict access to the source sheet

Ive even split the data - so its split by quarter/year - to reduce the need for 500 rows, but even then I have too many rows!

In summary - how do I display a report which has more than 500 rows on a published dashboard where I dont want the User to log in?

Thanks!

jmyzk_cloudsmart_jp

Hi @1845sarah

As I tested, using a published report, I was able to display more than 500 rows.

https://app.smartsheet.com/b/publish?EQBCT=9b298609b0144036a7892d6fc5393319

To add a published report to a dashboard, you need to get the 'embedded code.'

Then, use the 'Web Content' widget to show in the dashboard.