Analyze Your Power BI Data with AI

Connect your Power BI account, query semantic models with DAX, and turn governed results into analysis, charts, and dashboards.

Microsoft OAuthRead-only accessPersonal workspace

Connect with Microsoft

Authorize your Power BI account with OAuth, create a personal connector, and sync the workspaces and content available to that user.

Permission-aware access

Formula Bot follows the connected user’s Power BI permissions. Semantic-model queries require Read and Build access and use that user’s security context.

Synced BI catalog

Browse synced workspaces, semantic models, reports, and dashboards. Semantic models are queryable; reports and dashboards are listed as context only.

What You Can Analyze

Semantic Model Analysis

“Summarize revenue and margin by region”
“Which products drove this quarter’s change?”
“Compare actuals with target by month”

Charts & Dashboards

“Chart the monthly trend from this semantic model”
“Build an executive dashboard from these results”
“Explain the biggest movements in these KPIs”

Detailed Setup Guide

Step-by-step instructions for connecting and configuring Power BI.

Explore Other Connectors

Google Analytics

Connect Google Analytics 4 to Formula Bot and analyze website traffic, user behavior, and conversions using AI-powered natural language queries.

Google Search Console

Connect Google Search Console to Formula Bot and analyze search performance, keyword rankings, and indexing with AI-powered queries.

Google Ads

Connect direct and MCC-managed Google Ads accounts to analyze campaigns, keywords, search terms, costs, and conversions with AI-powered GAQL.

Tableau

Connect Tableau Cloud to Formula Bot and chat with synced dashboards, views, and datasources as BI collections.

Airtable

Connect a read-only Airtable base and analyze selected tables in chat and refreshable dashboards.

Google Sheets

Connect Google Sheets to Formula Bot and sync spreadsheet data for AI-powered analysis, dashboards, reports, and scheduled refreshes.

Google Drive

Connect Google Drive to Formula Bot and import spreadsheets, CSVs, and data files for AI-powered analysis without manual downloads.

Dropbox

Connect Dropbox to Formula Bot and import Excel, CSV, and TSV files for AI-powered analysis without manual downloads.

OneDrive

Connect Microsoft OneDrive to Formula Bot and import Excel, CSV, and TSV files directly into AI chats, dashboards, and reports.

SharePoint

Connect Microsoft SharePoint to Formula Bot and import Excel, CSV, and TSV files from document libraries for AI-powered analysis.

Google BigQuery

Connect Google BigQuery to Formula Bot and analyze massive datasets in your data warehouse using AI-powered natural language queries.

Snowflake

Connect your Snowflake data warehouse to Formula Bot and analyze your data with AI-powered natural language queries. No SQL required.

MySQL

Connect your MySQL database to Formula Bot and query your data using AI-powered natural language. No SQL expertise required.

PostgreSQL

Connect your PostgreSQL database to Formula Bot and explore your data with AI-powered natural language queries. No SQL required.

Supabase

Connect your Supabase Postgres database to Formula Bot and analyze live product, user, and event data with AI-powered natural language queries.

Microsoft SQL Server

Connect Microsoft SQL Server to Formula Bot and explore enterprise data with AI-powered natural language queries. No SQL expertise needed.

Frequently Asked Questions

Formula Bot runs DAX against Power BI semantic models (datasets) the connected user can read and build against. Synced reports and dashboards are visible as metadata but are not queried directly.

Yes. A Power BI administrator must enable Semantic Model Execute Queries REST API under Tenant settings → Integration settings. The setting was previously named Dataset Execute Queries REST API.

Not in this release. Power BI connectors are personal because delegated OAuth and row-level security reflect the connected user’s identity. Each user must connect Power BI in their personal workspace.

Power BI limits each execute-queries request to 100,000 rows, 1,000,000 values, and 15 MB. Formula Bot uses filtered or aggregated DAX and asks you to narrow results that exceed those limits.

Ready to Analyze Power BI with AI?

Connect Power BI Sign in