Q&A in Power BI service and Power BI Desktop

Stella981
• 阅读 415

What is Q&A?

Sometimes the fastest way to get an answer from your data is to ask a question using natural language. For example, "what were total sales last year." Use Q&A to explore your data using intuitive, natural language capabilities and receive answers in the form of charts and graphs. Q&A is different from a search engine -- Q&A only provides results about the data in Power BI.

This article is the jumping off point for all things Q&A. Select a link below to learn how Q&A works in Power BI service (dashboards and reports), Power BI Desktop (reports), Power BI Embedded, and Power BI mobile.

Note

Power BI Q&A only supports answering natural language queries asked in English. You can also try out a preview feature for questions asked in Spanish. In Power BI Desktop, go to File, Options and settings, Options and look for the Preview Features tab. Check the box for Spanish language support for Q&A.

Q&A in Power BI service and Power BI Desktop

Asking the question is just the beginning. Have fun traveling through your data refining or expanding your question, uncovering trust-worthy new information, zeroing in on details and zooming out for a broader view. You’ll be delighted by the insights and discoveries you make.

The experience is truly interactive…and fast! Powered by an in-memory storage, response is almost instantaneous.

Q&A for consumers

When a colleague shares a dashboard with you, you'll find the Q&A question box on the dashboard in Power BI service (app.powerbi.com), at the bottom of the dashboard in Power BI mobile, and above the visualization in Power BI Embedded. Unless the owner has given you edit permissions, you'll be able to use Q&A to explore data but won't be able to save any visualizations created with Q&A.

Q&A in Power BI service and Power BI Desktop

Q&A for creators

If you're a creator of Power BI reports or have edit permissions to a dataset, you'll find the Q&A question box on the dashboard in Power BI service, and on each report page in Power BI service and Power BI Desktop. Any visualization you create using Q&A can be saved to a dashboard and saved in a report.

Q&A in Power BI service and Power BI Desktop

In addition to using Q&A to explore their data, creators and dataset owners can improve the Q&A experience for consumers by modifying their datasets, adding featured questions, and enabling and disabling Q&A for on-premises live connection datasets. In Embedded scenarios, developers can choose between 2 modes: interactive and result only.

How does Q&A know how to answer questions?

Which datasets does Q&A use?

How does Q&A know how to answer data-specific questions? It relies on the names of the tables, columns, and calculated fields in the underlying dataset. So what you (or the dataset owner) call things is important!

For example, suppose you had an Excel table named “Sales”, with columns titled “Product”, “Month”, “Units Sold”, “Gross Sales”, and “Profit”. You could ask questions about any of those entities. You could ask "show sales, "total profit by month", "sort products by units sold", and more.

Q&A can answer questions that are based on how your dataset is organized. How would this work for data in Salesforce? When you connect to your salesforce.com account, Power BI generates a dashboard automatically. Before you start asking questions with Q&A, take a look at the data displayed in the dashboard visualizations and also at the data displayed in the Q&A dropdown.

  • If the visualizations' axis labels and values include "sales", "account", "month", and "opportunities", then you can confidently ask questions such as: "Which account has the highest opportunity, or show sales by month as a bar chart."
  • If the dropdown includes "salesperson", "state", and "year", then you can confidently ask questions such as: "which salesperson had the lowest sales in Florida in 2013."

If you have website performance data in Google Analytics, you could ask Q&A about time spent on a web page, number of unique page visits, and user engagement rates. Or, if you’re querying demographic data, you might ask questions about age and household income by location.

Which visualization does Q&A use?

Q&A picks the best visualization based on the data being displayed. Sometimes data in the underlying dataset(s) is defined as a certain type or category and this helps Q&A know how to display it. For example, if data is defined as a date type, it is more likely to be displayed as a line chart. Data that is categorized as a city is more likely to be displayed as a map.

You can also tell Q&A which visualization to use by adding it to your question. But keep in mind that it may not always be possible for Q&A to display the data in the visualization type you requested.

点赞
收藏
评论区
推荐文章
blmius blmius
2年前
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
文章目录问题用navicat导入数据时,报错:原因这是因为当前的MySQL不支持datetime为0的情况。解决修改sql\mode:sql\mode:SQLMode定义了MySQL应支持的SQL语法、数据校验等,这样可以更容易地在不同的环境中使用MySQL。全局s
Wesley13 Wesley13
2年前
java将前端的json数组字符串转换为列表
记录下在前端通过ajax提交了一个json数组的字符串,在后端如何转换为列表。前端数据转化与请求varcontracts{id:'1',name:'yanggb合同1'},{id:'2',name:'yanggb合同2'},{id:'3',name:'yang
Easter79 Easter79
2年前
sqoop job用法
创建JOB sqoopjobDmapreduce.job.queuename'root.bi'creatext\_test\_jobimportconnectjdbc:mysql://xxxx:3306/test?tinyInt1isBitfalseusernamexxxpasswordxxx
Easter79 Easter79
2年前
Synopsys SpyGlass CDC 学习 (一)
SpyGlass工具目前包含:SpyGlassLint,CDC,RDC,DFTADV,Power. 是业界RTLSignoff的重要工具.CDC介绍CDC(ClockDomainCrossing)的前端设计中最常见的问题,在RTL中要恰当的处理每个异步的控制信号和数据信号,否则就会出现亚稳
Stella981 Stella981
2年前
Power BI Desktop 2020年6月功能摘要
作者:BI佐罗!(https://pic3.zhimg.com/v2c07e43b97d09e06e62ac3999b0300f32_b.jpg)官方翻译如下:我们对此版本进行了重大更新!我们非常高兴地宣布本月将提供一些功能:自动页面刷新,层次切片器,现代功能区和AI见解。最重要的是,我们有一些新功能和更新将真正改善您的报告:移动布局
Stella981 Stella981
2年前
Mongo Connector for BI
官网地址:https://www.mongodb.com/products/biconnector(https://www.oschina.net/action/GoToLink?urlhttps%3A%2F%2Fwww.mongodb.com%2Fproducts%2Fbiconnector)它目前包含两个组件:1.mongosqld
Wesley13 Wesley13
2年前
HKC(红裤衩)5大亮点, 揭秘HKC(红裤衩)的大体框架
\\项mu靓点\\①无佣jin模式:不伤ren脉,tou资人zhuan钱的同时加速释放自己的收yi②底部点火,伞下大额ye绩出现自己会主动增加账号或tui广拿加速shou益,自动裂变。③chi币计划可以激励市场领导人屯bi,收bi,推广加速,形成一bi难求,jia格稳定上zhang。④MKji团HKEx平t
Wesley13 Wesley13
2年前
MySQL部分从库上面因为大量的临时表tmp_table造成慢查询
背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_
Python进阶者 Python进阶者
1个月前
Excel中这日期老是出来00:00:00,怎么用Pandas把这个去除
大家好,我是皮皮。一、前言前几天在Python白银交流群【上海新年人】问了一个Pandas数据筛选的问题。问题如下:这日期老是出来00:00:00,怎么把这个去除。二、实现过程后来【论草莓如何成为冻干莓】给了一个思路和代码如下:pd.toexcel之前把这
稚然 稚然
2星期前
Power BI实战:数据分析可视化
//下仔のke:https://yeziit.cn/13819/项目初始化是一个项目开始阶段的重要步骤,它包括为项目的顺利实施和执行做好各项准备工作。具体的步骤可能因项目的规模、复杂度和类型而有所不同,但通常包括以下几个方面:确定项目目标:在项目开始之前,