Looker–Power BI Connector: Requirements, Setup & Best Practices (Complete Guide)

Integrating Looker with Microsoft Power BI is now possible using the Looker–Power BI Connector — a powerful way to bring governed LookML data directly into Power BI for reporting and visualization.

In this guide, we’ll cover:

• Connector requirements
• Setup steps
• Key features
• Limitations & best practices

What is the Looker–Power BI Connector?

The Looker–Power BI Connector allows you to:

• Connect Power BI Desktop directly to Looker Explores
• Use LookML-defined metrics inside Power BI
• Build and publish reports in Power BI

👉 In simple terms:

It acts as a bridge between Looker’s semantic layer and Power BI’s visualization layer.

Requirements for Looker–Power BI Connector

Before setting up, ensure you meet these requirements 👇

1. Power BI Requirements

• Install Power BI Desktop on your system
• Enable support for custom connectors (.mez files)

2. Looker User Requirements

• Valid Looker account
• Must have **explore permission** to access Explores
• For large queries (>5000 rows), need:
• **download_without_limit permission**

3. Looker Instance Requirements

• Connector must be enabled by admin
• BI Connectors setting must allow Power BI access
• For private or self-hosted setups:
• Looker version 25.16+ required
• Network must allow connector traffic

4. Admin Configuration

• Admin must enable Power BI connector toggle in Looker
• Some instances:
• Enabled by default (Google Cloud core)
• Disabled by default (original Looker)

Step-by-Step Setup Guide

1️⃣ Enable Connector in Looker

• Go to Admin → Platform → BI Connectors
• Enable Power BI connector

2️⃣ Download Connector File

• Download .mez file (e.g., looker_1.4.3.mez)
• Place it in:

Documents\Microsoft Power BI Desktop\Custom Connectors

3️⃣ Configure Power BI Desktop

• Open Power BI → Options → Security
• Enable:
• “Allow any extension to load” (custom connectors)
• Restart Power BI

4️⃣ Connect to Looker

• Go to Get Data → Search “Looker”
• Enter Looker instance URL
• Sign in
• Select Explore

5️⃣ Choose Connection Mode

👉 Recommended: DirectQuery

• Live connection to Looker
• Avoid Import mode issues

⚠ Import mode can:

• Break LookML logic
• Trigger heavy queries

How Data Appears in Power BI

Once connected:

• Fields appear like:

ViewName.FieldType.FieldName

Field Types:

• dim → Dimensions
• mea → Measures
• fil → Filters

Based on LookML definitions

Key Features

1. DirectQuery Support

• Real-time querying from Looker
• No data duplication

2. LookML Reusability

• Use predefined business logic
• Avoid rebuilding metrics

3. Filter Integration

• Supports LookML filters & parameters
• Works inside Power BI filters pane

4. Row-Level Security (RLS)

• Publish reports to Power BI Service
• Apply role-based access control

Important Limitations

1. Row Limits

• Default query limit = 5000 rows
• Requires permission to remove limit

2. Limited Measure Support

Supported:

• SUM, COUNT, AVG, MIN, MAX

Not supported:

• Median (slow)
• Stddev, variance

3. Import Mode Issues

• Poor performance
• Incorrect measure evaluation
• Disabled filters

4. Aggregation Conflicts

Power BI may:

• Re-aggregate Looker measures
• Cause inconsistent results

5. Filter Limitations

• Limited support for complex filters
• Some combinations not supported

Best Practices

Use DirectQuery Mode

• Ensures correct LookML logic
• Better performance

Keep LookML Simple

• Avoid complex aggregations
• Use supported measure types

Control Row Limits

• Assign download_without_limit if needed

Use Looker for Modeling

• Keep logic in LookML
• Avoid duplicating in Power BI

Monitor Usage

• Use Looker System Activity
• Track Power BI queries via API logs

Recommended Architecture

Data Warehouse → LookML (Looker)
                       ↓
               Power BI (Connector)

✔ Centralized logic ✔ Scalable architecture ✔ Clean governance

When Should You Use This Connector?

Use it when:

• You want to reuse LookML in Power BI
• Teams use both tools
• Migrating from Looker to Power BI

Final Thoughts

The Looker–Power BI Connector is a powerful hybrid solution that combines:

• Looker’s semantic modeling
• Power BI’s visualization strength

But it comes with trade-offs:

• Limited aggregations
• Performance considerations
• Dependency on LookML

👉 Best approach:

• Use connector for integration use cases
• Use data warehouse + dbt for long-term architecture

👉 Subscribe to Tech Tutorials BI for powerful tutorials on OBIEE, Looker, and Power BI 🚀 Learn BI step-by-step and grow your data career! 🔔 https://youtube.com/@TechTutorialsbi