Forum Discussion
Automatic Refresh from Azure Ressources
HI Anonymous,
What connector are you test? Web, file or azure connector? Please share more detail information to help us clarify your senior:
How to Get Your Question Answered Quickly
If you mean file with URL, please refer to the following link to know how to find out the root file URL to get data in power bi:
Use OneDrive for Business links in Power BI Desktop
If you mean web connector, check below link about use web connector with rest API and OAuth mode:
OAuth2 REST API as data source
For azure services, normally they are cloudy datasource and not require a gateway to refresh. Any advanced operation enabled in query table steps? (merge, combine, reference, invoke custom function, mix on-premise Datasource)
Regards,
Xiaoxin Sheng
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