{"id":958,"date":"2021-04-03T12:54:35","date_gmt":"2021-04-03T10:54:35","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=958"},"modified":"2021-04-03T13:07:26","modified_gmt":"2021-04-03T11:07:26","slug":"migrate-your-power-bi-reports-to-use-the-azure-text-analytics-api-v3-1","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=958","title":{"rendered":"Migrate your Power BI Reports to use the Azure Text Analytics API V3.1"},"content":{"rendered":"\n<p>When you want to use the API Version 3.1 (actually in preview, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cognitive-services\/text-analytics\/whats-new\">https:\/\/docs.microsoft.com\/en-us\/azure\/cognitive-services\/text-analytics\/whats-new<\/a>) with Power BI and you used before the Version 2, you must do some changes. The first change is, that you must use another URL with the region inside, e.g.: <em>https:\/\/northeurope.api.cognitive.microsoft.com\/text\/analytics\/v3.1-preview.1\/<br><\/em>The next change to identify the language is very easy, because the returned JSON field names not <em>detectedLanguages<\/em> in this version, the name is only <em>detectedLanguage<\/em> without an \u201cs\u201d. Okay, easy, right? To detect the Key Phrases there are no changes. But to detect the sentiment there are more changes to do. You see the M code below, the JSON gives us now the  confidence score and it delivers three columns for positive, neutral, and negative. Before you get only one column. Mostly it is enough to analyze only the positive column, because when it contains a small number, it is more negative, when it contains 0.5, it is neutral. So, you can expand the columns with M and use only the positive column and start to analyze the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/04\/image.png\"><img decoding=\"async\" loading=\"lazy\" width=\"605\" height=\"385\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/04\/image.png\" alt=\"\" class=\"wp-image-959\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/04\/image.png 605w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/04\/image-300x191.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2021\/04\/image-471x300.png 471w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/figure>\n\n\n\n<p><a href=\"https:\/\/1drv.ms\/u\/s!AuCpjqDqctTWksJA2BvbkxHKAa8zdw?e=bA9mxn\">Attached<\/a> you will find an example Power BI Report<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you want to use the API Version 3.1 (actually in preview, https:\/\/docs.microsoft.com\/en-us\/azure\/cognitive-services\/text-analytics\/whats-new) with Power BI and you used before the Version 2, you must do some changes. The first change is, that you must use another URL with the &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=958\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/958"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=958"}],"version-history":[{"count":3,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/958\/revisions"}],"predecessor-version":[{"id":962,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/958\/revisions\/962"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}