Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Use Cortana with Power BI

Cody Schneider••9 min read

Using Cortana to ask questions about your business data turns your Power BI dashboards into an on-demand, conversational analyst. Instead of digging through reports to find a specific number, you can just ask your computer for it. This article will show you exactly how to set up the Power BI and Cortana integration, ask effective questions, and create custom answers for a seamless experience.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

What is the Cortana and Power BI Integration?

You probably already know Power BI as Microsoft's powerful business intelligence tool for creating interactive reports and dashboards. Cortana, on the other hand, is the AI-powered personal assistant built into Windows. When you connect them, you unlock a new way to access your data.

The integration allows you to use your voice or the Windows search bar to ask natural language questions about the data in your Power BI reports. For example, instead of opening Power BI, finding the latest sales report, and filtering it for last quarter's revenue, you could simply type or say, "Power BI show last quarter's revenue." Cortana will process the request, find the relevant information in your dataset, and display a chart or number directly in its interface. It’s all about getting quick, direct access to insights without interrupting your workflow.

Getting Started: What You'll Need

Before you can start querying your data, a few things need to be in place. Make sure you have the following ready to go:

  • A Power BI Pro or Premium Per User License: The free version of Power BI does not support the Cortana integration.
  • Windows 10 Version 1511 or Later: Most users will already have this, but it's a good idea to check for updates if you run into any issues.
  • Admin Permissions in Your Power BI Tenant: You'll need access to the Power BI Admin Portal to enable the integration for your organization. If you don't have it, you'll need to ask your Power BI administrator to flip the switch for you.
  • Synced Accounts: You must be signed into your Windows 10 device with the same corporate account that you use to log into Power BI. Your login credentials for your PC and Power BI must match.
  • A Published Power BI Report: You need at least one report published to the Power BI service containing a dataset you want to query.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Enabling Cortana in Your Power BI Admin Portal

The first step is to enable the feature in your organization’s Power BI settings. This is a one-time setup that an administrator needs to perform.

  1. Log into your Power BI account at app.powerbi.com.
  2. Click the Settings gear icon in the top-right corner and select Admin Portal from the dropdown menu.
  3. In the Admin Portal, click on Tenant settings on the left-hand navigation panel.
  4. Scroll down until you find the "Integration settings" section.
  5. Locate the option for Cortana and expand it.
  6. Switch the toggle to Enabled.
  7. Choose who can use this feature. You can apply it to the Entire organization or select Specific security groups to limit access to certain teams, like the marketing or sales departments.
  8. Click Apply.

After you apply the change, it might take a few minutes to propagate across your organization's accounts.

Making Your Data "Cortana-Ready"

Once the admin setting is on, you need to tell Power BI which specific datasets Cortana is allowed to access. You do this in the settings for each individual dataset you want to make available. It's a great way to control which data is searchable while keeping sensitive information private.

Enable Your Dataset for Cortana Access

  1. Navigate to the workspace containing the report and dataset you want to use.
  2. Find the dataset (it will have an orange icon) and click the three dots (More options) next to its name.
  3. From the menu, select Settings.
  4. In the dataset settings, find the section labeled Q&A and Cortana.
  5. Check the box that says, Allow Cortana to access this dataset.
  6. Click Apply to save your changes.

Optimize Reports with Clear Names

Cortana's ability to understand you depends heavily on how a report's data is structured and named. It uses the names of tables, columns, measures, and even report pages to figure out what you're asking for. Overly technical or abbreviated names like "sales_fy22_q3_final_rev" are hard for both humans and AI to parse.

Before publishing your reports, take a moment to clean up your data model. Use simple, descriptive names for your fields, like "Quarterly Revenue," "Total Customers," or "Website Clicks." This tiny step makes the conversational experience infinitely better because users can ask questions using the same language they see in the report.

How to Query Your Power BI Data with Cortana

With everything set up, a new world of data access opens up right from your Windows search bar. Simply click the Cortana icon or the search bar on your taskbar and start typing or speaking your questions.

Here are some examples of what you can ask:

  • To open a report by its name: Show my Sales Performance report
  • For specific KPIs or numbers: Power BI latest user count
  • For trends over time: Power BI show leads by month for last year
  • For filtered totals: What were the total signups from Canada in June in Power BI
  • For comparisons: Power BI compare revenue in Q1 vs Q2
GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Tips for Effective Questions

  • Prefix with "Power BI": If Cortana confuses your query with a web search, starting your question with "Power BI" helps it understand you're specifically asking about your internal data.
  • Use Field Names from Your Dataset: Your best bet for an accurate answer is to use the names of columns and measures as they appear in your reports. If your sales column is named "Revenue," asking for "revenue" is more likely to succeed than asking for "money made."
  • Keep it Simple at First: Start with a broader question like "Power BI show sales by product." Cortana will return a chart. Looking at that chart often gives you ideas for a more specific follow-up question, like "Power BI show sales for Product A."

Pro Tip: Creating Custom Cortana "Answer Cards"

For frequently asked questions, you can go a step further and design specific "Answer Cards" inside Power BI. An Answer Card is a report page specially designed to be the single, definitive answer that Cortana shows for certain types of queries. It's a fantastic feature that gives report creators more control over the user experience.

How to Design a Great Answer Card

An Answer Card isn't a full dashboard, it's a small, focused visual designed to fit perfectly inside the Cortana window.

  1. Create a New, Dedicated Page: In your Power BI Desktop report, create a new page that will serve only as an Answer Card.
  2. Use the 'Cortana' Page Size: With nothing selected on the canvas, go to the Format pane. Under Page Size, select Cortana from the "Type" dropdown. This automatically resizes the canvas to the recommended dimensions.
  3. Keep it Simple: Place a single, clear visual on the page. A KPI card showing a key metric, a simple line chart, or a gauge works perfectly. Avoid using tables or dense visuals that will be hard to read in a small window.
  4. Give the Page a Smart Name: The name of your report page is critical. Name it to match the question people will ask. For a card that shows customer count, a page name like "Total Number of Customers" is ideal. You can also add synonyms in the page format settings to cover variations of the question.

When a user asks a question that strongly matches your Answer Card's name and content, Cortana will prioritize showing it over trying to generate a new visual on the fly, giving a faster and more predictable result.

What to Do When Cortana Isn't Cooperating

Sometimes things don't go as planned. If you're having trouble getting answers from Cortana, here are some common issues and their solutions.

Problem: "Cortana can't access Power BI."

If you get a message saying Cortana can't connect, double-check the basics. Is the toggle enabled in the Admin Portal? Are you logged into Windows with the exact same account you use for Power BI? A simple reboot after verifying these settings often resolves connection problems.

Problem: "I can't find an answer for that in Power BI."

This is the most common error. It usually means Cortana either didn't understand your question or couldn't find a matching field in the enabled datasets. To fix this, try rephrasing your question using the exact names of columns, tables, and measures from your report. You should also go back to Power BI Service and confirm that the dataset you're querying is, in fact, enabled for Cortana access.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Problem: "The data seems wrong or not what I expected."

Cortana doesn't invent numbers, it just presents data from your Power BI dataset. If an answer seems incorrect, the issue almost always lies in the underlying Power BI data model. The person who built the report should check for incorrect data relationships, misconfigured DAX measures, or unfiltered data that might be throwing off the results.

Final Thoughts

Integrating Cortana with Power BI transforms your dashboard from a static resource you have to hunt for into a dynamic assistant you can query instantly. By enabling the right settings and designing reports with natural language in mind, you and your team can get quick data answers right from the Windows desktop, making your organization more data-informed in every decision.

This approach helps bridge the gap between complex data tools and the simple questions many business users have. At Graphed, we're focused on taking this idea even further. We built an AI data analyst that lets you not only ask questions but also build entire dashboards using simple, conversational English. Instead of just pulling a single chart, you can connect all of your core marketing and sales tools - like Google Analytics, Shopify, and Salesforce - and say, "create a dashboard showing my sales funnel from a Facebook ad click to final purchase," and get a live, interactive report in seconds. The goal is to simplify the whole analytics process, from connecting data to getting answers. You can try Graphed and see just how easy it is to chat with your data and get the insights you need.

Related Articles