Melihat laporan bawaan di sheet yang terhubung ke Google
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Halaman ini menjelaskan cara melihat laporan tampilan di spreadsheet yang terhubung ke Google. Panduan ini juga
menjelaskan cara mendownload laporan ke file lokal.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-03 UTC."],[],[],null,["# View prebuilt reports in Google connected sheets\n\nThis page explains how to view view reports in Google connected sheets. It also\nexplains how to download reports to a local file.\n\nAfter you [set up prebuilt reports](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#script), if you have access to Google Workspace,\nyou can view the results in Google connected sheets. For more information,\nsee [Using Connected Sheets](/bigquery/docs/connected-sheets).\n\nIf you don't have access to Google Workspace, you can [view the reports in Looker Studio](/backup-disaster-recovery/docs/monitor-reports/view-reports-lookerstudio)\nor download prebuilt reports in a CSV file. For instructions, see [Download prebuilt reports](#download).\n\nTo view prebuilt reports in Google connected sheets, do the following:\n\n1. In the Google Cloud console, go to the **BigQuery Studio** page:\n\n [Go to BigQuery Studio page](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** panel, click the arrow_rightexpander arrow to expand a dataset.\n3. Select a prebuilt report. For example, `Backup Jobs Summary`.\n4. From **Export** , click **Explore with sheets**.\n\n A new tab opens in connected sheet with the report data.\n\nDownload prebuilt reports\n-------------------------\n\nAfter you set up the prebuilt reports, you can download them to a local file. For more information, see\n[Downloading and saving query results from the Google Cloud console](/bigquery/docs/writing-results#downloading-saving-results-console).\n\nTo download prebuilt reports in BigQuery, do the following:\n\n1. In the Google Cloud console, go to the **BigQuery Studio** page:\n\n [Go to BigQuery Studio page](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** panel, click the arrow_rightexpander arrow to expand a dataset.\n3. Select a prebuilt report. For example, `Backup Jobs Summary`.\n4. Click **Query** and select either **In new tab** or **In split tab**.\n\n A new tab opens with a sample query.\n5. Write a query based on the field names that are populated in the **Schema** tab. For example, you can use the following query to download the entire report.\n\n SELECT * FROM `\u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e.BackupandDR_reports.Backup Jobs Summary`.\n\n6. Click **Run** to display the preview of the query results.\n\n7. From **Save results** , select **CSV (local file)** to download report to a local file."]]
