This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

BigQuery configuration. Workspace logs export. 0 rows

Posted 2 weeks ago
Alango89
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hello, this is my first time using bigquery.

I have configured the exports of my workspace. When I access the Activity table, it appears with 0 rows. How is that possible? 

I would like to be able to access Classroom grades through Google Sheets, Power Bi, or LookerStudio.

Thanks in advance for the help.

4 1 45
Topic Labels
1 REPLY 1

Posted on --/--/---- --:-- AM
ms4446
Staff
Reply posted on --/--/---- --:-- AM

Hi @Alango89 ,

This can happen for a few reasons. Here are some steps to troubleshoot:

  1. Verify Export Configuration: Ensure that your Workspace exports are correctly configured. Double-check the settings in the Google Admin console to confirm that data export is enabled for the correct services and that it’s set to export to BigQuery.

  2. Check Permissions: Make sure that the BigQuery service account has the necessary permissions to read and write data in your dataset. You might need to grant bigquery.dataEditor or bigquery.user roles.

  3. Time Lag: Sometimes, there might be a delay between the data being generated and it appearing in BigQuery. Wait a little longer to see if the data shows up.

  4. Query Filters: If you are using filters in your queries, ensure they are correctly set. A common mistake is having overly restrictive filters that return no results.

Regarding accessing Classroom grades, here are some ways to achieve that:

  1. Google Sheets: You can connect BigQuery to Google Sheets using the BigQuery Data Connector for Sheets. This allows you to run queries directly from Sheets and visualize the data.

  2. Power BI: Power BI supports connecting to BigQuery. You can use the Google BigQuery connector available in Power BI to fetch and visualize your data.

  3. Looker Studio: Looker Studio offers native integration with BigQuery. You can create reports and dashboards by directly connecting to your BigQuery dataset.