Forum Discussion
PowerBI connection to non-US bigquery dataset
I have a bigquery dataset that is located in europe-west3. I can authenticate via google account or service account, both works. It shows my datasets. Yet, when i try to open a dataset to see my tabl...
GrowthNatives
Super User
Super UserHello burkhard & Patryk_Matera ,
To solve this issue that you are facing with location
You can try using Simba ODBC driver by following these steps :
1. Download the Simba ODBC driver for BigQuery from Google
2. Go to System DSN → Add → Simba ODBC Driver for Google BigQuery.
3. Fill in the Details - Project Id: your-project-id
Dataset Id: your-dataset-id
Location: europe-west3
4. In Power BI Desktop → Get Data → ODBC.
Select your required DSN .
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]