Power BI

Power BI AI Integration

Data & Analytics

With Power BI connected, your assistants can answer questions from reports, dashboards, datasets, dataflows, and apps across your workspaces, within your workspace permissions and row-level security. Ask for the executive dashboard or total revenue by region this quarter.

Access Mode
Read Only
Setup Time
~5 minutes
Auth Method
OAuth 2.0
Available soon Read-only by default

Connect Power BI to JoySuite

Your assistants query Power BI datasets and read reports when someone asks.

Available soon. Setup takes about 5 minutes once it's ready.
Join Waitlist

What you can do

Finding the right report usually means opening workspace after workspace, and a new question means writing DAX.

Find a report by name

"Show me the executive dashboard"

Ask for a report or dashboard, such as the executive dashboard, from any workspace.

See which KPIs are off target

"Which KPIs are trending below target?"

Ask which KPIs are trending below target.

Query a dataset

"What's total revenue by region for this quarter?"

Ask a question in plain language and get results from a dataset without writing DAX.

Get a current figure

"What's our current inventory level?"

Ask for a single number, such as current inventory, from your datasets.

Find reports on a topic

"Find all reports related to customer satisfaction"

List the reports related to a subject such as customer satisfaction.

Combine Power BI data with your CRM

"What Power BI data relates to accounts in my CRM?"

See Power BI figures for the accounts in your CRM.

What Your Assistants Can Access

JoySuite securely connects to Power BI, making these resources available to your assistants.

📊

Reports

Access Power BI reports and their pages, visuals, and filters.

Report Name Pages Visuals Filters Workspace
📈

Dashboards

Query dashboard tiles and their pinned visuals and metrics.

Dashboard Name Tiles Data Source Refresh Time
🗃️

Datasets

Send DAX queries to datasets to retrieve specific data.

Dataset Name Tables Measures Relationships
📁

Workspaces

Browse workspaces to find reports and dashboards.

Workspace Name Contents Members Type
🔄

Dataflows

Access dataflow entities and their refresh status.

Dataflow Name Entities Refresh Status Schedule
📋

Apps

Access published Power BI apps and their content.

App Name Reports Dashboards Published Date

Connector Commands

Use these specialized commands to interact with your Power BI data directly in conversations.

/powerbi report

Get Report

Retrieve a specific report and its visual data.

/powerbi dashboard

Get Dashboard

View dashboard tiles and their metrics.

/powerbi query

Query a Dataset

Execute a DAX query against a dataset.

/powerbi search

Search Content

Find reports and dashboards by name or keyword.

/powerbi refresh

Check Refresh

View dataset refresh status and history.

/powerbi workspaces

List Workspaces

Browse available workspaces and their contents.

Commands respect your permissions and access settings.

Connect Power BI to Your Other Tools

See how Power BI works with your other connected tools.

📈
+
☁️

Power BI + Salesforce Integration

Put Power BI analytics next to Salesforce account data when you ask about a customer.

📈
+
🟣

Power BI + Teams Integration

Find the Power BI metrics behind topics your team discusses in Teams.

📈
+
🔷

Power BI + Dynamics 365 Integration

Reference Power BI data alongside Dynamics 365 records when you ask about an account.

📈
+
❄️

Power BI + Snowflake Integration

Combine Power BI visualizations with the underlying Snowflake data in one answer.

Permissions & Access Control

You control exactly what JoySuite can access within Power BI.

Default

Read Access

Standard access level for querying Power BI data.

  • View reports and dashboards
  • Send DAX queries to datasets
  • Access workspace contents
  • Respects row-level security
Not Available

Write Access

Write access is not available for this connector.

  • Power BI is read-only by design
  • Data modifications happen upstream
  • Query results are ephemeral
  • Full audit logging available
For your IT team Security & safety How JoySuite works with your LMS

Frequently asked questions

Does JoySuite store my Power BI data?

No. JoySuite connects to Power BI via Microsoft Graph API and queries data in real-time. Your data stays in Power BI. JoySuite reads it from Power BI when you ask a question and doesn't keep a copy.

Which reports and dashboards can JoySuite access?

JoySuite can access content based on your Power BI workspace permissions. It respects your organization's access controls.

Can JoySuite send DAX queries?

Yes. JoySuite can execute DAX queries using natural language, returning results from your datasets.

How long does setup take?

About 5 minutes. Connect via OAuth, authorize access, and start asking questions about your data.

Does this respect row-level security?

Yes. All queries respect Power BI's row-level security (RLS) settings and user permissions.

Related Connectors

Other connectors people use with Power BI.

Tableau

Tableau

Data & Analytics
Snowflake

Snowflake

Data Warehouse
Microsoft Dynamics 365

Microsoft Dynamics 365

CRM & Sales
Microsoft Teams

Microsoft Teams

Communication

Connect Power BI when it launches

Join the waitlist and we'll tell you when the Power BI connector is available.

Join Waitlist