hidden: true
Google Big Query - Power BI (or any other BI Tool)
🔗 Connecting Power BI to BigQuery via Service Account
To connect Power BI to your data hosted in the Medecision platform (Google BigQuery), you'll need a Google Cloud project with appropriate IAM permissions and billing enabled. Below are the steps to set up everything required on your end.
✅ Step-by-Step Instructions
Step 1: Set Up Google Cloud Organization
Option A – Already using Google Workspace?
If your organization uses Google Workspace, you likely already have a GCP Organization.\ ➡️ You can skip to Step 2.
Option B – New to Google Cloud?
If you do not yet have a Google Cloud Organization:
Create a Google Workspace account\ https://workspace.google.com/signup/businessstarter/welcome
Log into Google Cloud Console using that Google Workspace account\ A Google Cloud Organization will be automatically created at:\ https://console.cloud.google.com
⚠️ Note: Consumer Gmail accounts (e.g., @gmail.com) cannot create a GCP Organization.
Step 2: Create a Google Cloud Project
Click “New Project”
Fill in:
Project Name (e.g.,
Clientname-BI-Integration)Organization: Select your domain (e.g.,
clientdomain.com)Click Create
Step 3: Enable Billing
Link an existing billing account or create a new one:\ https://console.cloud.google.com/billing/create
Step 4: Enable BigQuery API
Ensure the correct project is selected
Click Enable
Step 5: Medecision Creates and Sends a Service Account Key
Medecision will:
Create a service account with read-only access to your specific BigQuery datasets
Generate a JSON key file
Share the key securely with your team
🔐 Do not share this key publicly — treat it like a password.
Step 6: Connect Power BI to BigQuery
Once you receive the service account key:
Open Power BI Desktop
Click Get Data > Google BigQuery
Choose “Use a service principal”
Upload the
.jsonkey file from MedecisionSelect your datasets and build reports
🔗 Power BI Docs:\ https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-google-bigquery
📌 Summary of Required Actions
Step | Action | Link |
1 | (If needed) Create Google Workspace | |
2 | Create GCP Project | |
3 | Set Up Billing | |
4 | Enable BigQuery API | |
5 | Receive Service Account from Medecision | (We will provide securely) |
6 | Connect via Power BI |
If you have any issues setting this up, please contact your Medecision technical contact for support.