Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
Microsoft Power BI
Google Gemini AI

Connect Microsoft Power BI and Google Gemini AI integrations

Explore ready-made Microsoft Power BI and Google Gemini AI templates and start automating in minutes.

Get started free

Create a custom workflow

Transform your data insights instantly by connecting Microsoft Power BI triggers with Google Gemini AI actions through intelligent automation. Automatically feed dashboard updates and data changes into Google Gemini AI's advanced analytical capabilities, delivering real-time AI-powered business intelligence without manual intervention.

Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

Microsoft Power BI
Trigger: Watch Apps
Google Gemini AI
Action: Select an action
1. Select a trigger

  • Triggers when an app is last updated.

2. Select an action

  • Creates a new file search store.

  • Deletes a file from a selected files search store.

  • Deletes a file search store.

  • Extracts structured data from text or files.

  • Generates a response for the provided input.

  • Generates a video using the general purpose Gemini model family.

  • Generates a video using the Veo models.

  • Generates an image using Gemini's image generation capabilities.

  • Generates an image using the imagen models.

  • Generate vector representations (embeddings) for the text or file you provide.

  • Generate high-quality, stereo audio from text prompts or from images.

  • Generates an audio file based on text input and settings.

  • Returns detailed information about a file in a file search store.

  • Retrieves details about a file search store.

  • Retrieves the full details of a single interaction (e.g. from a deep research agent).

  • Performs an arbitrary authorized API call.

  • Runs a deep research agent by Gemini.

  • Generates text responses from prompts without requiring an account or connection.

  • Uploads a file so it can be used in the completions or in file search stores.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

Connect Google Gemini AI as a trigger and Microsoft Power BI as an action through Make's automation platform to create intelligent workflows. When Google Gemini AI detects changes in your data or dashboard updates, it triggers an automated workflow that feeds this information directly to Microsoft Power BI as an action. Microsoft Power BI then processes the data using its advanced natural language processing and analytical capabilities, generating AI-powered insights that improve your business intelligence. This integration allows you to automatically send data from Google Gemini AI triggers to Microsoft Power BI actions, enabling real-time data enrichment and automated analysis without manual intervention.

Add/Delete Rows in a Dataset Table
Adds or deletes rows of a specified push dataset table.
Action
Copy a Report
Copies an existing report.
Action
Create a Dashboard
Creates a new dashboard.
Action
Create a Dataset
Creates a new dataset.
Action
Create a file search store
Creates a new file search store.
Action
Delete a Dataset
Deletes a dataset.
Action
Delete a file in a file search store
Deletes a file from a selected files search store.
Action
Delete a file search store
Deletes a file search store.
Action
Delete a Report
Deletes a report.
Action
Load more

How to set up Microsoft Power BI and Google Gemini AI in 5 easy steps

Date

·

Duration

Step 1

Set up your Google Cloud project

Before you can connect Google Gemini AI to Make, you need to create a project in Google Cloud Platform. Log in with your Google account, click to create a new project, give it a name, and select a location. This project serves as the foundation for generating the access credentials you'll need later.

Date

·

Duration

Step 2

Get your API key from Google AI Studio

Navigate to Google AI Studio and log in with your Google account. Click 'Get API key' and then select 'Create API key' while choosing your Google Cloud project from the list. Copy the API key that appears and keep it safe, as this is what allows Make to securely communicate with Google Gemini AI.

Date

·

Duration

Step 3

Connect Google Gemini AI in Make

Open Make and add a Google Gemini AI module to your workflow. When prompted, click 'Create a connection' and paste the API key you copied from Google AI Studio into the designated field. You can give your connection a custom name to help you identify it later, then save to complete the setup.

Date

·

Duration

Step 4

Register your app in Microsoft Entra ID

To connect Microsoft Power BI to Make, go to the Microsoft Entra ID section in the Azure portal and click 'App registrations'. Create a new registration by entering a name for your application and the callback URI 'https://www.integromat.com/oauth/cb/microsoft-power-bi'. After registering, copy both the Client ID and Tenant ID from the overview page, and then generate a client secret from the 'Certificates and secrets' section.

Date

·

Duration

Step 5

Complete the Power BI connection in Make

Add a Microsoft Power BI module to your Make scenario and click 'Create a connection' when prompted. Enter the Client ID, Tenant ID, and Client secret you copied from your Microsoft app registration. Follow the on-screen instructions to finish the authentication process, and your connection will be ready to use in your automation workflows.

AI-powered analytics: Microsoft Power BI and Google Gemini AI benefits

Integrate Microsoft Power BI and Google Gemini AI to transform complex data into natural language insights, automated reports, and intelligent commentary that makes analytics accessible to everyone.

Date

·

Duration

AI-powered data insights and narratives

Automatically generate natural language summaries and explanations of Power BI data using Gemini AI to make complex analytics accessible to non-technical stakeholders.

Date

·

Duration

Intelligent report generation

Transform Power BI dashboard data into comprehensive, context-aware reports and presentations through Gemini's advanced language capabilities.

Date

·

Duration

Automated data query interpretation

Enable natural language queries to Power BI datasets by using Gemini to translate user questions into proper data retrieval commands and format responses conversationally.

Date

·

Duration

Smart alert enrichment

Improve Power BI alerts with AI-generated contextual analysis and recommendations from Gemini to help teams understand what actions to take based on data changes.

Support

FAQs

Everything you need to know about Make. Can't find the answer you're looking for? Please chat to our team.

By integrating Microsoft Power BI with Google Gemini AI through Make, you can automatically generate natural language insights, summaries, and explanations of your Power BI data. Gemini AI can analyze complex datasets, create narrative reports, identify trends, and even generate predictive insights that make your dashboards more accessible to non-technical stakeholders. Make's visual automation platform enables you to set up workflows where Gemini AI processes Power BI data exports, generates intelligent commentary, and feeds these insights back into your reporting system—all without writing code.

With Make, you can create powerful automated workflows such as: automatically generating executive summaries of Power BI reports using Gemini AI's language capabilities, translating dashboard insights into multiple languages for global teams, creating conversational explanations of complex metrics, generating data-driven content for presentations or emails, and setting up alerts where Gemini AI analyzes Power BI data anomalies and provides contextual explanations. Make's intuitive drag-and-drop interface lets you connect these applications in minutes, scheduling workflows or triggering them based on specific events in your Power BI environment.

No coding skills are required. Make's visual platform allows you to integrate Microsoft Power BI and Google Gemini AI through an intuitive drag-and-drop interface. You select the applications, choose the triggers and actions you want, and configure the data flow between them. Make handles all the technical complexity behind the scenes, including API connections, authentication, and data formatting. This means business analysts, data professionals, and decision-makers can create sophisticated AI-powered analytics workflows without relying on development teams, significantly reducing implementation time and costs.

Integrating Microsoft Power BI with Google Gemini AI through Make transforms raw analytics into actionable intelligence. While Power BI excels at visualizing data, Gemini AI adds a layer of interpretation and context that helps teams understand what the numbers really mean. You can automatically generate plain-language explanations of trends, get AI-powered recommendations based on your data patterns, create customized reports for different audiences, and even have Gemini AI answer specific questions about your Power BI datasets. This combination accelerates decision-making by making complex data insights accessible to everyone in your organization, not just data experts. Starting with Make is risk-free and you can begin automating these insights today.