Power BI integration with Cognitive Services

[darogael]

Hi Power BI community!

I've been working on building my own Power BI report with Sentiment Analysis. I have been following the steps described in this article and am currently stuck at building the Power BI connection with Cognitive Services.

So far I have made a connection to my Azure SQL database table successfully. Then I made a data connection using Blank Query and adding the code described in the article, however, I changed the API key.

However, now I'm getting asked to add a parameter. This wasn't described in the article. As you can see below, the only parameter option I have is Twitter.

However, after selecting Twitter below is what I get

Has anyone seen this before? Thanks in advance.

[Greg_Deckler]

I believe there is a security setting that you need to disable to make this happen. 

[darogael]

Thanks for responding back so quickly. I did try that for both my data connections. I tried Public, Organizational and None but still the same problem.

[v-yuezhe-msft · Accepted solution]

@darogael,

Go to File > Options and settings > Options and then Current File > Privacy , select the ignore privacy levels option as shown in the following screenshot, then check if the issue is solved.


Regards,

[darogael]

Thanks guys. This resolved the problem. I should have read through the Q/A in the blog 🙂

[TaherBouzid]

please guys does it always work for you ? 

I really followed all these steps before but  I am facing this error 😕 I copy carefully the api key but also the same thing 😕 does you fixe this  before?

[pbinmens]

@TaherBouzid did you got a solution? I tried also everything, following exactly all steps, and I always get the same credentials error