Power BI via Looker Connector

Connect Power BI to your Looker semantic layer to access Explores and governed metrics without rebuilding your data model.

Overview

The Looker–Power BI Connector lets you connect Power BI to your Looker semantic layer. Your existing Explores, governed metrics, and dimensions are available directly in Power BI — no rebuilding required. This is the recommended path for customers who want consistent metric definitions across reporting surfaces.

For full setup details, follow Google's official Looker–Power BI Connector documentation. The steps below cover what's specific to your Daasity setup.

---

Prerequisites

Admin side (one-time setup)

A Looker admin must enable the connector before any user can set it up:

1. In your Looker instance, go to Admin → BI Connectors

2. Toggle on Microsoft Power BI

The BI Connectors toggle is off by default. If you don't see the Admin menu, contact your Looker admin or [e-mail].

User side

• Power BI Desktop installed on your machine

• Your Looker login credentials (the same credentials you use to log into your Looker instance directly)

• The Looker–Power BI Connector .mez file — download from Google's connector page

---

Setup steps

Follow Google's official guide for the full walkthrough:

• Set up the Looker–Power BI Connector

When prompted to sign in, use your Looker credentials — not your Google account or Daasity login.

---

Things to know

DirectQuery vs. Import Mode

Use DirectQuery. Import Mode has real limitations with Looker measures and is not recommended.

Row limit

Queries cap at 5,000 rows by default. If you need more, contact [e-mail] — your Looker admin can grant download_without_limit permission.

Power BI Service (Cloud)

Power BI Desktop is the starting point. Once you've built reports in Desktop, you can publish them to Power BI Service. See Google's Power BI Service guide for the additional steps required.

---

Need help?

Contact [e-mail].