What is Microsoft Power BI Q&A
Power BI Q&A is a self-service BI feature available only online. First, you upload a workbook to the Power BI site. Then, you can type your own questions or select from a list of suggested questions. These questions do not require you to learn a specialized query or expression language, however. Instead, you ask questions by using your own words. Q&A automatically selects the best type of visual display for the data it returns from the query, which might be an interactive chart, a map, or a graph. You can override this behavior by including the name of the visualization that you prefer in the question or by changing the visualization after viewing the selection from Q&A.
To start Q&A, you must have at least one Power BI–enabled workbook uploaded to your Power BI site. Click the ellipsis in the lower-right corner of the workbook tile, and then click Add To Q&A. Next, click the Search With Power BI Q&A link at the upper-right corner of the page. Start typing your question in the balloon that’s displayed at the top of the page. Q&A can autocomplete words you enter and displays sample questions that you can use to refine your question further. When you finish the question, Q&A displays the results. You might need to adjust the source workbook by clicking Show More in the navigation pane and selecting a different workbook, as shown in Figure 5.7. To change the current visualization, select one of the items in the Show As list in the navigation pane on the left side of the screen.
FIGURE 5-7 A Power BI Q&A question and results.
Here are few examples of the types of phrases that you can use with the report pictured throughout this chapter:
- Show total sales by category for Adventure Works
- Which subcategory of bikes has the highest sales?
- Show a list of customers in Washington
Note Because a common idea can be expressed in many ways, you can add synonyms to a data model to help users find information when they do not know the specific names of objects in that model. For more information about working with synonyms, see http://office.microsoft.com/en-us/excel-help/add-synonyms-to-a-power-pivot-excel-data-model-HA104143188.aspx? CTT=5&origin=HA104149776. Additionally, there are optimizations to your data that can help improve the search results from Q&A. Learn more about these techniques at http://office.microsoft.com/en-us/excel-help/enhancing-and-tuning-excel-power-pivot-workbooks-for-power-bi-q-a-HA104143202.aspx? CTT=5&origin=HA104149776.