![how to search for keywords in text messages on galaxy note8 how to search for keywords in text messages on galaxy note8](https://www.lifewire.com/thmb/I4Z0G3ohzXvFrJeSXmc8OYZidpU=/1779x1334/smart/filters:no_upscale()/contactinfo-32afce2c99db4fd79b2dff7db8038043.jpg)
![how to search for keywords in text messages on galaxy note8 how to search for keywords in text messages on galaxy note8](https://i.ebayimg.com/images/i/122712110091-0-1/s-l1000.jpg)
JsonContent = Text.ToBinary(JsonRequest, TextEncoding.Ascii), JsonRecords = Text.FromBinary(Json.FromValue(Source)), Still in Home tab, click Advanced Query and paste the following code: In the Query Editor's Home tab, click the drop down menu below the icon of New Source and select Blank Query. Read here how to create Power BI Templates. Note: Using a parameter here, will allow you to export the Power BI Desktop file as a template and share with colleagues and friends without sharing your API Key. In the Parameters dialog, set APIKey as Name and paste the API Key that you obtained from Microsoft Cognitive Services into the text box Current Value. In the Query Editor's Home tab, click Manager Parameters, then select New Parameter.
![how to search for keywords in text messages on galaxy note8 how to search for keywords in text messages on galaxy note8](https://www.technipages.com/wp-content/uploads/2017/09/Delete-Include-protected-message.png)
If the Query Editor is not open, click Edit Queries.
#How to search for keywords in text messages on galaxy note8 code
In this section we'll prepare the advanced Power Query code that we'll need for the Key Phrase API.Ĭontinue with the Power BI Desktop file that was created in Part 1. Preparing the API queries - A parameter and a query function Make sure you don't have duplicate keys, and that you don't have any blank values as messages. Note: If you didn't follow the Part 1 here, and you wish to try this tutorial on your own data, please prepare a table with text messages and unique keys (e.g. We'll need the API key that can be copied from here (as shown in the following screenshot). Make sure you have an account on Microsoft Cognitive Services (Signup here), and a (free) subscription to Text Analytics Preview. In our example: We will be able to see which key phrases triggered the highest number of shares, and slice them by positive, neutral or negative sentiment, as shown in this report (click here to view it on ): When we are done, we will be able to create stunning reports that will correlate key phrases with our metrics. In this part, we will extract key phrases from those messages using Microsoft Cognitive Services Text Analytics (AKA Azure Machine Learning). In the first part of the tutorial here we imported Clinton's and Trump's Facebook messages and their number of shares.