Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Automatic Refresh from Azure Ressources

I've created a dataset which uses some url's who pointed to some azure ressources like cognitives servives.. The url's using vaiables in M (Power Query)   When I want to configure an automatic ref...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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