Sentiment Analysis using Power BI and Microsoft Cognitive Services

Подписаться 22 тыс.

Просмотров 14 тыс.

50% 1

Download the PDF to keep as reference
theexcelclub.co...
FREE Power BI course - Power BI - The Ultimate Orientation
theexcelclub.co...
Or on Udemy
www.udemy.com/...
Or on Android App
play.google.co...
Carry out a sentiment analysis like the big brand...only free with Power BI and Microsoft Cognitive Services.
this video will cover
Obtain a Text Analytics API Key from Microsoft Cognitive Services
Power BI - Setting up the Text Data
Setting up the Parameter in Power BI
Setting up the Custom function Query(with code to copy)
Grouping the text
Running the sentiment analysis by calling the custom function.
Extracting the sentiment from the returned Json file.
Sign up to our newsletter
theexcelclub.co...
Watch more Power BI videos
• Power BI
Watch Excel Videos
• Learn Excel - Playlist
Join the online Excel and PowerBI community
plus.google.co...

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 55

@matheusmartinsmoreno 7 лет назад

great work! I was trying to do this for some time, but it was not working. Thanks fr this wrapup.

@yoshihirokawabataify 7 лет назад

Awesome, Send a table of data from Power BI Desktop Query to Microsoft Cognitive Services, is Quick, Suitable.

@PaulaWeb3andCrypto 7 лет назад

Glad you liked it! and there is even more it can do....

@narayannayak 5 лет назад

Hi Paula, Its a very good detailed explanation but I need few suggestion and help to implement in real time system. My requirement is like this I have CRM 365 online data (lets say one entity is comments) . I want to use the whole real time CRM data and prepare one power BI report which will show in CRM dashboard. Can you help and suggest please asap.

@gopushaji1927 Год назад

Hi, I was trying this step by step. But when I 'Invoke Custom Function', I come across this error: -- Formula.Firewall: Query 'sentiment run' (step 'Invoked Custom Function') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Unable to go further. Please help??

@YouTubeUTube1 3 года назад

Invoke Custom Function not giving option of NewTable in drop down

@lqqqqqqqqqqqqqqqqlq 5 лет назад

Hi Paula, First thanks for the nice video. Would you be able to help me with the error I get when trying to copy/paste your M query code. On the following row the “{“” are underlined for me with the error message: Invalid syntax. JsonRequest = “{“”documents””: ” & JsonRecords & “}”, How should I correct that?

@johng5295 3 года назад

Awesome. Great content.

@adelaidenembaleni3380 5 лет назад

I Paula, nice video. Thanks for this, but I tried doing this steps and I GET THIS ERROR. Can you please help?"Formula.Firewall: Query 'Sentiment run' (step 'Invoke Custom Function') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination."

@lexh7714 7 лет назад

I tried all steps but im always i get some error about i have to connect anonymously , but when i tried that , it fails (

@kaykay21254143 6 лет назад

same!! i hope she'll tell us how to solve it :(

@YouTubeUTube1 3 года назад

can any one please help

@MohsinAli-un8wk 4 года назад

Thanks it’s very helpful, Can you please upload a video with new column which tell wether text is positive negative or neutral,thanks

@rachidboumnijel2419 6 лет назад

Thanks Paula, but I can't seem to get the query to work. JsonRequest = “{“” the underlined is invalid?

@FPrimeHD1618 6 лет назад

I'm getting the same thing

@FPrimeHD1618 6 лет назад

I figured out what was wrong. The quotation marks being used here are not recognized as quotation marks in Advanced Editor. Go through all the m-code and replace all quotation marks with quotation marks. See the difference? Quotation marks provided: “” Updated quotation marks: ""

@zell71 5 лет назад

Thanks Paula - fascinating!

@rafaelknuth8202 6 лет назад

Superb! Thanks for sharing, Paula! Can you shed some light on how to write that function in M-Language? I have a basic understanding of Power Query and M-Language, and I would like to learn to do it by myself. Thanks!

@jbyxxx 7 лет назад

Hi Paula, Thanks a lot for the detailed explanation. I wonder if there is a way to make it for a text in another language/German?

@wadanda 7 лет назад

Thanks Paula, nice, simple and extremely useful

@PaulaWeb3andCrypto 7 лет назад

You are most welcome

@vicmilanski9582 4 года назад

great work!

@miker8560 5 лет назад

getting an error on your code JsonRequest = “{“”documents””: ” & JsonRecords & “}”, its saying invalide identifier on the first quotations before the curly brackets. why is that?

@Nyx666 4 года назад

Replace quotes. Type those quotes manually through Keyboard

@npithia 7 лет назад

Great tutorial. To make this work, do we need to have Azure account?

@mohamedhosman 7 лет назад

Very nice, thank you very much

@jonnyparsons3217 7 лет назад

Could you post the code needed at 3:45. Thanks :-)

@PaulaWeb3andCrypto 7 лет назад

You can find a copy on the website theexcelclub.com/sentiment-analysis-with-power-bi-and-microsoft-cognitive-services/

@jonnyparsons3217 7 лет назад

Thanks Paula. I've figured it out now.

@PaulaWeb3andCrypto 7 лет назад

Fab

@周以騏 7 лет назад

hello, I followed your clear and nice videos step by step . However, when I click the "invoke custom function" and then it finished its query, there is a column added, but the column's values all show error, why?

@PaulaWeb3andCrypto 7 лет назад

did you remove all duplicates and blank rows and ensure that the column headers are correct?

@周以騏 7 лет назад

yes,i check these twice again, but still occurred the same.........

@PaulaWeb3andCrypto 7 лет назад

is the text is data type text? can you ping me a copy of the file?

@周以騏 7 лет назад

ok, here is a link about the file: 1.powerBI document: 1drv.ms/u/s!Av7dgV9fGRose_ge-pR94-hYcOU 2.socurce file: excel file: 1drv.ms/f/s!Av7dgV9fGRosf6c_XLjnGpTu5KI thanks~

@周以騏 7 лет назад

btw, here is my email, if you would have the solutions to this, send me the document to this mail :g29481490@gmail.com i would appreciate it , thx!

@imvivran 7 лет назад

Hi - I am getting the following error when I am updating the queryExpression.Error: The name 'Source' wasn't recognized. Make sure it's spelled correctly.I am unable to run the query. Please advise.

@kokweikhong5974 7 лет назад

same here

@kokweikhong5974 7 лет назад

ok found the reason why, it's because the codes were incomplete. Use these scripts instead of the one in the website (I wonder why they put up incomplete scripts to make us fail): let Source = (Source as table) as any => let JsonRecords = Text.FromBinary(Json.FromValue(Source)), JsonRequest = "{""documents"": " & JsonRecords & "}", JsonContent = Text.ToBinary(JsonRequest, TextEncoding.Ascii), Response = Web.Contents("westus.api.cognitive.microsoft.com/text/analytics/v2.0/sentiment?", [ Headers = [#"Ocp-Apim-Subscription-Key"= APIkey, #"Content-Type"="application/json", Accept="application/json"], Content=JsonContent ]), JsonResponse = Json.Document(Response,1252) in JsonResponse in Source

@PaulaWeb3andCrypto 7 лет назад

Vivek please add (Source as table) as any => to the beginning of the code. I have updated the website. thanks for bringing this to my attention

@PaulaWeb3andCrypto 7 лет назад

I put a lot of effort into sharing knowledge, but as I am only human, I can make mistakes. Why would I want you to fail. Your solution is correct, you could also just add (Source as table) as any => to the start of the code, as seen in the video at 3m 45 sec

@imvivran 7 лет назад

Thank you very much for your response. I have been able to use the code and get past that stage. However, once I invoke the custom function and run the query, I get an additional step to specify how I would like to connect (Message: Please specify how to connect (Edit Credentials)). I had tried all the possible options in the dialogue box, and only "Connect Anonymously" let me pass through. But even then, I get the following error as a result:An error occurred in the ‘’ query. DataSource.Error: Web.Contents failed to get contents from 'westus.api.cognitive.microsoft.com/text/analytics/v2.0/sentiment' (400): Bad Request Details: DataSourceKind=Web DataSourcePath=westus.api.cognitive.microsoft.com/text/analytics/v2.0/sentiment Url=westus.api.cognitive.microsoft.com/text/analytics/v2.0/sentimentNeed your advise :)

@killingyou321 4 года назад

People having trouble with the JsonRequest or the code, copy the code from OP in this thread: community.powerbi.com/t5/Desktop/Azure-text-analyics-API-access-to-the-resource-is-forbidden/td-p/438850