Forum Discussion
Automatic Refresh from Azure Ressources
I've used the web connector in Power BI Desktop. On the Desktop version the import and also the refresh works fine. The error is only on the web version on powerbi.com
Hi Anonymous,
What data credentials mode are you used on power bi service side? Have you configured data credentials on power bi service side? (please confirm you are using same authorization mode on desktop and service side)
According to error messages, it seems like your request missed some contents some remote servers prevent these requests. Can you please share some sample query formulas that you used in the query editor? (Notice: do mask on sensitive data parts)
Regards,
Xiaoxin Sheng
- On Power BI Desktop I use my organizational account. This option Isn’t available on the service. I have only the above listed authentification types.
I use the same code from this website:
https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi-key-phrases
I have only inserted a variable into the web url for a language.HI Anonymous ,
AFAIK, web connector does not support to use OAuth mode on power bi service side.
I guess you haven't finished reading the whole document, right? For that sample code, it already added credentials into query steps('api key' of your account), you only need to use anonymous authorization mode on power bi desktop side. (service side data credentials configure should same as desktop report configured)
You select Anonymous because the Text Analytics service authenticates you using your access key, so Power BI does not need to provide credentials for the HTTP request itself.
Regards,Xiaoxin Sheng
I added a API Key, if not, the application does not work.
If I use Anonsmous Login, I get a 404 Error when I try to configure the Refresh.
Failed to update data source credentials: Web.Contents failed to get contents from 'https://demopl.cognitiveservices.azure.com/text/analytics/v2.1/keyPhrases' (404): Resource Not FoundHide details
Activity ID: 7f3dc5c0-14e3-4b98-81af-d22c37013554 Request ID: 3f534b84-ddcc-4a09-d9c1-d17fc7c1b095 Status code: 400 Time: Tue Jan 14 2020 10:47:20 GMT+0100 (Central European Standard Time) Service version: 13.0.11747.315 Client version: 1912.2.031 Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/ Did it on your side work?