Receiving empty tables when calling bigrquery in R language

[MarcioFreitas55]

Hello there!

I'm trying to get some data from GCP and I'm having issues with that. My company has an application in R and we are trying to connect and request data using the bigrquery package.

I have the same credentials that we used to connect through PowerBI within a JSON file. Thus, I managed to call the function bq_auth(path = 'credentials.json') and connect to GCP.  I can get the list of tables, however, when I ask for the table using the functions tbl() or bq_table_download(as_bq_table(), n_max = 10) I get an empty table/data.frame.

Has anyone had a similar problem or know the solution to this?

[RC1]

@MarcioFreitas55 I would recommend you to do step by step execution. Also be sure to check the return type of `as_bq_table()` function.

Can you try the below code manually and see if you are able to download the table

library(bigrquery)

# authenticate
# use if notebook is outside gcp
#bigrquery::bq_auth(path = '/Users/me/restofthepath/bigquery- credentials.json')

bq_table_download("my-project-id.dataset-id.table", page_size = 100)

---

@MarcioFreitas55 wrote:

as_bq_table()

---