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 refresh for each datasource in the power bi.com service, I cannot using the Authentication Method like oAuth which I use on One Drive etc.

I've only Anonymous, Windows and Basic and this don't work.

 

Error Message:

Failed to update data source credentials: Hide details

Activity ID:7427e891-dc85-45be-9e2d-926c7fbbf3de
Request ID:8918e10b-186c-c608-ed58-06fee6a07f64
Status code:400
Time:Wed Jan 08 2020 11:39:39 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/
Need Help

10 Replies

  • 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