Hi, I'm trying to connect to BigQuery using the native connector I'm getting this error because BigQuery is trying to connect to another dataset that i don't have access to. Does anyone know ...
mzanette
6 years agoRegular Visitor
Try to specify the project you are trying to connect in the m language:
let
Source = GoogleBigQuery.Database([BillingProject="Include-Billing-Project-Id-Here"])
See Considerations and Limitations section in https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery