Public dashboard missing data

Hi, I created a “public dashboard”. It displays a panel showing log entries from Loki. In Grafana, I can select different time frames (5 minutes, 1 hour, 12 hours, etc) from the drop down and the log entries display accordingly. In the public dashboard, the time-frame selector works, but I only see log entries to a certain entry (let’s call it “entry-A”), and not all the entries past that one which fit the time-frame selection. In other words, if I select 6 hours from the drop-down, I see only the the log entries back to entry-A. In the normal dashboard with the same time-frame, I see additional entries. If I switch to 12-hours, in the public dashboard nothing changes. I continue to only see entries to “entry-A”. In the normal dashboard, I see additionally entries back 12 hours.

I have checked my configuration, restarted, upgraded, and recreated the dashboard. Same problem.

Does anyone have an idea what could be the problem?

  • What Grafana version and what operating system are you using?
    AWS EC2 t3.large
    Linux Ubuntu 22.04.02 LTS
    Docker 23.0.2
    Docker Compose 2.17.2
    Grafana OSS 10.4.3 and OSS 11.0.1 (both fail)

  • What are you trying to achieve?
    I want to share a “public dashboard” and show the same data as the normal dashboard. The shared dashboard works, but it only shows a subset of the data.

  • How are you trying to achieve it?
    A “public dashboard” of the working dashboard.

  • What happened?
    The public dashboard works, but it only shows past events to a certain log entry, even when I select longer time frames. The older events display properly in the normal dashboard.

  • What did you expect to happen?
    I expect to see events based on the selected time-frame, exactly as it works in the normal dashboard. However, events older than “event-A” are not displayed in the “public dashboard”.

  • Troubleshooting
    I copied the working dashboard and created a new “public dashboard” but I had the same problem.
    I restarted Grafana. Same problem.
    I upgraded Grafana from 10.4.3 to the latest version 11.0.1. Same problem.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Below is the Docker Compose section used for Grafana OSS:

version: “2.1”
services:
grafana:
image: grafana/grafana-oss:latest
container_name: grafana
restart: unless-stopped
environment:
- GF_SECURITY_ADMIN_USER=xxxxxxxxxxxxx
- GF_SECURITY_ADMIN_PASSWORD=xxxxxxxxxxxxxx
- GF_SECURITY_ALLOW_EMBEDDING=true # used for iframe dashboards
- VIRTUAL_HOST=grafana.loc
- GF_SERVER_ROOT_URL=https://xxxxxxxxxxxxxxxxxxx
- GF_LOG_MODE=console file
- GF_LOG_LEVEL=info
- GF_DATABASE_TYPE=postgres
- GF_DATABASE_HOST=xxxxxxxxxxxxxxxxxxxxx
- GF_DATABASE_NAME=xxxxxxxxxxxx
- GF_DATABASE_USER=xxxxxxxxxxxx
- GF_DATABASE_PASSWORD=xxxxxxxxxxxxx
- GF_DATABASE_SSL_MODE=disable
- GF_SMTP_ENABLED=true
- GF_SMTP_HOST=xxxxxxxxxxxxxxx
- GF_SMTP_USER=xxxxxxxxxxxxxxx
- GF_SMTP_PASSWORD=xxxxxxxxxxxxx
- GF_SMTP_SKIP_VERIFY=true
- GF_SMTP_FROM_ADDRESS=xxxxxxxxxxxxxxxx
- GF_SMTP_FROM_NAME=xxxxxxxxxxxxxx
volumes:
- ./grafana:/var/log/grafana
ports:
- 3000:3000

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    The log contains no errors.

  • Did you follow any online instructions? If so, what is the URL?
    I did not follow any specific instructions.

I have fixed my problem.
Public dashboard items default to a line limit of 100 rows. Non-public dashboard items default to a line limit of 1000 rows.
Edit a dashboard component, look in the Query tab, and you will see “Line limit:1000”. Expand the Options and you will see this value appears in greyed text, indicating that it is a default value. However, it does not apply to public dashboards.
If you enter your own value, including the default value of 1000, it will apply to public dashboards. This fixed my issue.
Note that there are several things which limit the number of rows displayed including the data source (Eg. Loki), the Grafana config file entries (or environment variables if running in Docker), and the above setting.