Not able to download complete data in excel from iframe

Bug reports
1

Hi,

I have create a report where I show the count a messages sent of daily basis.

If I try to download the same data from metabase question page I'm getting the full downloaded result but while embedding the same in web page and downloading it from there is giving me incomplete data.

Kindly help me with this bug.

2

Hi @s_dhaval
Post "Diagnostic Info" from Admin > Troubleshooting.
How many rows are you getting normally, and how many rows are returned via embedding?
Is it SQL or GUI question?

3

hi @flamber

I think it is GUI issue - from metabase between 1st March to 31st March I'm getting count around 500k where as from iframe I'm getting only 100k also this data download is only from 29th march to 31st March.

I have added the format in which I'm downloading the data. I have check the payload also of iframe which is passing correct date.

Screenshot from 2022-09-02 16-34-52
Screenshot from 2022-09-02 16-34-52927×248 19.9 KB

Screenshot from 2022-09-02 16-20-52
Screenshot from 2022-09-02 16-29-18
Screenshot from 2022-09-02 16-29-181752×33 6.32 KB

4

It is a SQL Questions **

5

@s_dhaval

  1. Post "Diagnostic Info" from Admin > Troubleshooting.
  2. So when you view in iframe, then your Number visualization only shows 100k? I'm having difficulties understanding what you are writing and showing in screenshots.
6 
{
  "browser-info": {
    "language": "en-GB",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.14.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.14.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.14.1+1",
    "os.name": "Linux",
    "os.version": "3.10.0-1160.el7.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.2 (Debian 14.2-1.pgdg110+1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-02-17",
      "tag": "v0.42.1",
      "branch": "release-x.42.x",
      "hash": "629f4de"
    },
    "settings": {
      "report-timezone": "Asia/Kuala_Lumpur"
    }
  }
}

@flamber On Metabase as well as on iframe UI I can see 500k count, but while downloading data from metabase I can see 500k rows of data while if I download it from iframe I can only see 100k rows of data in excel.

7

@s_dhaval Upgrade to latest release 0.44.2: https://github.com/metabase/metabase/releases/latest