I've seen a few comments where users were able to connect to BigQuery using R-Script. I am able to connect in R-studio to BigQuery without issue, but I cannot connect from Power Bi to BigQuery using R. I have a feeling that I need to pass the Auth code somewhere- but I haven't found any documentation on how to do it.
Here is what I have:
sql <- "select * from Database.Table"
data <- query_exec(sql, project = project, useLegacySql = FALSE)
Details: "ADO.NET: R script error.
package 'bigrquery' was built under R version 3.3.3
httpuv not installed, defaulting to out-of-band authentication
Error: Can only use oob authentication in an interactive session