How to Use Gemini in Looker Studio

What Gemini in Looker Studio Actually Does

Looker Studio (formerly Google Data Studio) is Google's free browser-based dashboard and reporting tool. Gemini is Google's AI layer, and it is now integrated into Looker Studio Pro as three distinct features that let non-technical users query and present data without writing SQL or complex formulas.

Conversational Analytics: Ask questions about your connected data in plain English. Gemini generates a chart or table and shows the logic behind the answer so you can verify it.

Formula Assistant: Describe a metric in natural language, and Gemini writes the calculated field formula using your actual field names and Looker Studio functions.

Slides Integration: Export dashboard charts directly into Google Slides with AI-generated text summaries for each visualization.

None of these features is available in the free version of Looker Studio. All three require Looker Studio Pro.

What You Need Before Starting

Check these requirements before attempting setup.

Looker Studio Pro subscription: Pro is billed per workspace through Google Cloud billing. The free tier does not include any Gemini features.

Google Cloud organization account: You need a Google Cloud project with billing enabled. Personal Google accounts cannot access Gemini in Looker Studio even with a Pro license.

IAM permissions: A Google Cloud administrator must enable Gemini features at the organization level. For standard Conversational Analytics, users need Editor role in Looker Studio. For querying Looker-connected data sources specifically, each user needs the gemini_in_looker permission on the relevant Looker models.

Supported data sources for Conversational Analytics: BigQuery, Google Sheets, CSV uploads, and Looker database connections. Third-party connectors such as Salesforce, MySQL, or PostgreSQL are not yet supported for conversational querying.

Google Cloud documentation notes that Gemini features in Looker Studio are in Preview, meaning they are currently available at no additional cost but may require a separate purchase after the Preview period ends. Monitor your billing settings if you deploy these features in a production environment.

Step 1: Enable Gemini in Looker Studio Pro

1. Sign in to the Google Cloud Console.
2. Navigate to the Looker Studio admin panel at lookerstudio.google.com.
3. Click the gear icon in the top right to open Settings, then select Features.
4. Enable the Gemini features toggle. This applies organization-wide to all Pro users.
5. In the Cloud Console, go to APIs and Services, search for "Gemini for Google Cloud," and verify it is enabled for your project.

If you manage a full Looker instance (not just Looker Studio), you also need to grant the gemini_in_looker user attribute to any user who will query Looker-managed models through Conversational Analytics.

Step 2: Query Your Data with Conversational Analytics

Once enabled, Conversational Analytics appears as a panel on reports connected to supported data sources.

1. Open any report in Looker Studio connected to BigQuery or Google Sheets.
2. Click the Gemini sparkle icon in the top navigation bar, or look for the Ask a question button if your admin has enabled it at the report level.
3. Type a question in plain English. For example: "Which region generated the most revenue last month?" or "Show me daily active users over the past 60 days."
4. Looker Studio returns a chart or table and displays a "How this was calculated" dropdown. Always expand this panel before using the result.
5. If the answer is correct, click Add to report to save the visualization as a standard chart tile you can edit with all normal chart settings.

Conversational Analytics performs best on trend and ranking questions over clean datasets with descriptive column names. Datasets where columns are named clearly (for example, "revenue_usd" instead of "rev" or "amt") get significantly more accurate answers. Always verify the calculated logic before sharing AI-generated charts with stakeholders.

One gap existing guides do not address: Gemini cannot query across two separate data sources in a single Conversational Analytics session. If your report uses multiple data blends, you need to ask questions about one source at a time.

Step 3: Build Calculated Fields with the Formula Assistant

Looker Studio's formula syntax can be difficult to learn, especially for non-technical users. The Formula Assistant removes this barrier.

1. In edit mode, open the data source panel on the right side of the screen.
2. Click Add a field to open the field editor.
3. Click the Gemini wand icon next to the formula input bar.
4. Describe the metric you want: "Calculate the 30-day rolling average of daily orders" or "Show revenue as a percentage of the monthly total."
5. Gemini generates a formula using your actual field names. Review it before clicking Apply.

The Formula Assistant requires Editor role in Looker Studio. Viewers cannot create or edit calculated fields.

It works well for standard aggregate functions, moving averages, and percent-of-total calculations. It produces incomplete results for complex conditional logic or multi-step formulas involving deeply nested CASE statements. For those cases, treat the generated formula as a starting point and edit manually.

Step 4: Export Reports to Google Slides

The Slides integration is the most time-saving feature for teams that present data regularly.

1. In edit mode, open the Share menu at the top right.
2. Select Deliver to Slides.
3. Choose which charts from your report to include and select an existing Google Slides presentation or create a new one.
4. Check Add Gemini summaries to include an AI-written paragraph for each chart.
5. Click Export.

Looker Studio inserts each selected chart as an image and adds the AI-generated text block beneath it. Summaries describe the key finding: for example, "Revenue peaked in November, driven by a 22 percent increase in the North America region."

You need Viewer or Editor access in Looker Studio plus Editor or Owner access on the destination Slides file.

Review all summaries before sharing. Gemini's text is accurate on clear trends but can oversimplify or miss context on flat or ambiguous data.

Current Limitations

No write-back: Gemini reads and analyzes your data but cannot update records in connected sources.

Connector coverage: Conversational Analytics is limited to BigQuery, Google Sheets, CSV, and Looker connections. Most third-party connectors do not support it.

Single-source queries: You cannot ask a question that spans two different data sources in one session.

Preview status: Several features remain in Preview as of early 2026 and may require a paid add-on after the Preview period ends.

If your data lives outside Google's ecosystem or you are working from raw CSV files without a BigQuery setup, VSLZ handles end-to-end analysis from a direct file upload without requiring cloud infrastructure or IAM configuration.

Summary

Gemini in Looker Studio Pro adds three AI features: Conversational Analytics for natural-language queries, a Formula Assistant for calculated fields, and Slides integration for presentation-ready exports. All three require Looker Studio Pro, a Google Cloud project with billing enabled, and correct IAM permissions. For best results, use BigQuery or Google Sheets with well-named columns, verify all AI-generated logic before sharing, and review Slides summaries for accuracy before presenting to stakeholders.