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.
Hi @Alango89 ,
This can happen for a few reasons. Here are some steps to troubleshoot:
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.
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.
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.
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:
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.
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.
Looker Studio: Looker Studio offers native integration with BigQuery. You can create reports and dashboards by directly connecting to your BigQuery dataset.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |