en en ms fi fi fi ms fi fi fi fi fi ms hbs_lat ms sl ms fi fi fi ms ms fi fi it fi en fi fi en fi fi fi fi fi fi fi fi fi fi fi fi fi fi sq fi en fi fi fi fi fi eu fi fi fi de id fi fi fi fi fi fi fi fi fi fi fi fi fi tr fi fi fi ms en en en en en fi en en en en en en en en en en en en en en en fa en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en it en th fi fi fi fi fi fi fi fi fi fi fi fi fi fi ca en en id en en en en en en en en ms ms ms en en ml fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi en fi ms en en en fi vo fi fi fi fi fi ms sl fi fi en fi fi fi fi de fi fi id fi en fi fi sv fi fi fi hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko nb nl nl pl pt pt ru sv th tr zh zh ar he
Ask a question using natural language updates | Microsoft Power BI – blogi | Microsoft Power BI
Office 365 + Power BI
You did know that Power BI supports natural language queries, right? All you need to do is to add the Q&A button to your report and your customers will be able to navigate their data just by asking questions:
We have recently just released a set of new capabilities for Q&A for you to all enjoy;
Row level security over Cloud AS models
If you caught the November release of Power BI Desktop, you may have noticed that the Power BI team has released ‘Ask a follow up’. This new feature provides the ability to ask a related or follow up question using natural language. Great, right? But how does it work?
Let’s play out a simple scenario. Suppose you are a sales manager and ask what is the ‘top performing product by sales revenue’. After typing this into the Q&A textbox you be presented with an answer something like below:
Great, we can clearly see which products are performing and which are not. Now let’s suppose you wish to ask ‘How about in Australia’ implying you wish to see which products have the highest revenue in Australia. Before, you had to use the original query with the qualification; ie, top performing product by sales revenue in Australia. With the new follow up capability, you can now seamlessly ask these types of follow ups naturally without having to reconstruct a new question. Power BI will maintain your previous question, like that a normal  person and will try to understand your follow up based off the original question.
Let’s see this in action. Click on the ‘Ask a follow up button’ and then type in ‘What about in Australia’ and voila, it will now have understood what you meant and returned the visual below.
We support a range of different ways you can use a follow up question. You can modify the original question, ask a related question, augment the original question, and keep going until you get the answer you want.
Modifying the original question
There are several different ways you can request an answer to a similar but slightly modified question. First, you can use pronouns to ask a similar question that refers to part of the previous question:
Original Question: How many Chicago customers bought green products
Follow up:  How many Seattle customers bought them?
Original Question: Show the total sales to Chicago customers
Follow up:  What was it for 2016?
Second, you can use a key phrase such as “what about”, “instead”, “also”, or “include” to indicate you want to modify the previous question. Here are some examples:
Original Question: How many Chicago customers bought green products?
Follow up:  What about red products?
Original Question: Which Chicago customers bought green products?
Follow up: Show Seattle customers instead
Original Question: How many customers bought green products in store 6?
Follow up: Include store 7
Third, you can repeat a phrase from the previous question, with a slight modification to indicate what you’d like to change:
Original Question: Count the green products bought by customers in Chicago
Follow up:  In Seattle
Original Question: Count the green products bought by customers in Chicago
Follow up:  Red products
And finally, you can also modify your question by simply typing a phrase that should be used as an extension of your previous question like this:
Original Question: How many customers bought green products?
Follow up:  In 2017
Original Question: Show the total sales of green products by city
Follow up:  As a column chart
Asking an Entirely New Related Question
There’s nothing that restricts you to just modifications, however. You can also use pronouns to reuse parts of what you asked about earlier in entirely new questions:
Original Question: Count the Seattle customers
Follow up:  What did they buy last year?
Original Question: Which Seattle customers bought discontinued red products?
Follow up:  What is the average price of those products?
Augment the Original Question
You can also include additional columns, group or sort by a column, or display the result as a specific type of visual:
Original Question: Count the customers
Follow up:  Group by city
Original Question: List the products
Follow up:  Sort by total sales, descending
Original Question: Which customers bought cheese last month?
Follow up:  Include their ages
Original Question: Count the customers by city
Follow up:  As a bar chart
Putting It All Together
You can continue to ask additional follow up questions, honing and modifying as needed, effectively having an ongoing conversation with your data:
Original Question: Which Seattle customers bought red products
Follow up:  Count them
Follow up:  Show Chicago instead
Follow up:  Include green products
Follow up:  What about in 2017?
Follow up:  Group by state
Follow up:  As a column chart
Q&A now supports row level security
Power BI has added support for asking Q&A questions against cloud models with row-level security. This new capability involves security at all layers. In addition to standard prevention of access to restricted data, Q&A refuses to even acknowledge the existence of that data. When your users ask questions, Q&A will respect the row-level security you have implemented, carefully not recognizing values which that user doesn't have access to. So, for example, while the Western Region Sales Manager will be able to able to ask "How many tons of rice did Contoso order from Mary Jones last week?", since the Eastern Region Sales Manager isn't authorized to know about employees or accounts from other regions, both "Contoso" and "Mary Jones" will appear to be unrecognized when they type in that same question. For additional information on row-level security in cloud models, see https://docs.microsoft.com/en-us/power-bi/service-admin-rls.
We hope you enjoy these new capabilities, stay tuned for more updates!
Tilaa Power BI -uutiskirje
Rekisteröidy alla, niin saat uusimmat Power BI -tiedot suoraan Saapuneet-kansioon.
Maa Afganistan Ahvenanmaa Alankomaat Albania Algeria Amerikan Samoa Andorra Angola Anguilla Antarktis Antigua ja Barbuda Argentiina Armenia Aruba Australia Azerbaidžan Bahamasaaret Bahrain Bangladesh Barbados Belgia Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia ja Hertsegovina Botswana Bouvet'nsaari Brasilia Brittiläinen Intian valtameren alue Brittiläiset Neitsytsaaret Brunei Bulgaria Burkina Faso Burundi Cabo Verde Caymansaaret Chile Cookinsaaret Costa Rica Côte d'Ivoire Curaçao Djibouti Dominica Dominikaaninen tasavalta Ecuador Egypti El Salvador Eritrea Espanja Etelä-Afrikka Etelä-Georgia ja Eteläiset Sandwichsaaret Etelä-Sudan Etiopia Falklandinsaaret Fidži Filippiinit Färsaaret Gabon Gambia Georgia Ghana Gibraltar Grenada Grönlanti Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard ja McDonaldinsaaret Honduras Hongkong, erityishallintoalue Huippuvuoret Indonesia Intia Iran Irlanti Islanti Israel Italia Itävalta Jamaika Jan Mayen Japani Jemen Jerseyn voutikunta Jordania Joulusaari Kambodža Kamerun Kanada Kazakstan Kenia Keski-Afrikan tasavalta Kiina Kirgisia Kiribati Kolumbia Komorit Kongo Kongon demokraattinen tasavalta Kookossaaret Korean tasavalta Kosovo Kreikka Kroatia Kuwait Kypros Laos Latvia Lesotho Libanon Liberia Liechtenstein Liettua Luxemburg Macao, erityishallintoalue Madagaskar Malawi Malediivit Malesia Mali Malta Mansaari Marokko Marshallinsaaret Martinique Mauritania Mauritius Mayotte Meksiko Mikronesia Moldova Monaco Mongolia Montenegro Montserrat Mosambik Namibia Nauru Nepal Nicaragua Niger Nigeria Niue Norfolkinsaari Norja Oman Pakistan Palau Palestiinalaishallinto Panama Papua-Uusi-Guinea Paraguay Peru Pitcairn Pohjois-Makedonia Pohjois-Mariaanit Portugali Puerto Rico Puola Päiväntasaajan Guinea Qatar Ranska Ranskan eteläiset alueet Ranskan Guayana Ranskan Polynesia Réunion Romania Ruanda Ruotsi Saba Saint Barthélemy Saint Kitts ja Nevis Saint Lucia Saint Martin Saint Vincent ja Grenadiinit Saint-Pierre ja Miquelon Saksa Salomonsaaret Sambia Samoa San Marino São Tomé ja Príncipe Saudi-Arabia Senegal Serbia Seychellit Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakia Slovenia Somalia Sri Lanka St. Helena, Ascension, Tristan da Cunha Sudan Suomi Suriname Swazimaa Sveitsi Syyria Tadžikistan Taiwan Tansania Tanska Thaimaa Timor-Leste Togo Tokelau Tonga Trinidad ja Tobago Tšad Tšekin tasavalta Tunisia Turkki Turkmenistan Turks- ja Caicossaaret Tuvalu Uganda Ukraina Unkari Uruguay Uusi-Kaledonia Uusi-Seelanti Uzbekistan Wallis ja Futuna Vanuatu Vatikaanivaltio Venezuela Vietnam Viro Yhdistyneet arabiemiirikunnat Yhdistynyt kuningaskunta Yhdysvallat Yhdysvaltain Neitsytsaaret Yhdysvaltain pienet erillissaaret Zimbabwe
Haluan saada seuraavan Power BI -uutiskirjeen. Tietosuojatiedot.
Osallistuminen edellyttää henkilökohtaisten tietojesi siirtämistä muihin maihin, joissa Microsoft toimii, muun muassa Yhdysvaltoihin. Lähettämällä tämän lomakkeen suostut tietojesi siirtämiseen Kiinan ulkopuolelle. Tietosuojalauseke.
Mikä on Power BI?
Power BI on yritysanalytiikan työkalupaketti tietojen analysointiin ja merkityksellisten tietojen jakamiseen. Seuraa liiketoimintaa ja hanki nopeasti vastauksia monipuolisista raporttinäkymistä, joita voi käyttää kaikissa laitteissa.
Hanki viimeisimmät uutiset Power BI -blogista
Tilaa sähköpostitse Sinun on annettava kelvollinen sähköpostiosoite Olet antanut henkilökohtaisen sähköpostiosoitteen. Anna työpaikan tai oppilaitoksen sähköpostiosoite. Tapahtui virhe. Yritä myöhemmin uudelleen.
Näytä kaikki ladattavat tiedostot