Forum Discussion

BartdT's avatar
BartdT
Frequent Visitor
5 years ago
Solved

Can't Refresh without Gateway with Web API Source (new issue)

Hi all,   having read (nearly) all posts and solutions for similar issues, I cannot figure out why this isn't working. I have a published PowerBI report which is refreshing automatically without th...
Need Help
  • BartdT's avatar
    BartdT
    5 years ago

    Hi all, I received word from Microsoft (Power BI) Support with more information. I thought it was valuable to share it with you::

     

    We have got an update from our Product Engineering team:

    As we see that the User is using https and http urls to build the report. We checked with our SME they confirmed that, Power BI Service requires https urls for Web data sources to refresh. For non-secured urls (http), it's required to go through the gateway. By design.

     

    So an anonymous API feed using "http" will not allow for a scheduled refresh in the online Power BI service without a gateway. It needs to be an https one.

     

    Krgds,

    Bart

BartdT's avatar
BartdT
Frequent Visitor
5 years ago

Any luck? Gilbert 

 

Anyone knows how I can address this to Microsoft support?

GilbertQ's avatar
GilbertQ
Super User
5 years ago
Hi there

have you configured the data source credentials for the dataset?

Even though it is a web data source you still have to configure it with Anonymous access.
  • BartdT's avatar
    BartdT
    Frequent Visitor
    5 years ago

    GilbertQ 

    Hi, which configuration (and where) are you referring to? I'll share some info of the existing configuration in two places:

     

    1. On Desktop the source credentials are set to Anonymous and Privacy Level to None. Note that this is similar to another Web API I have and which does work and allows for automatic refresh in the Power BI Service (without the Gateway)

     

    2. As indicated, in Power BI service the scheduled automatic refresh is not allowed if this new Web API is included, at least not without the gateway. To do some additional checks, I've also used my personal gateway and added the data source to the gateway. Data Connection tests are succesful for all sources, also the new one, and I can schedule and refresh using the Gateway. After this step, I am not allowed to switch the Gateway off and set up the automatic refresh without the Gateway. So there's still some issue but not sure how to get more info on this.

     

    I wanted to share some screen shots of all this, but not sure how I can add these, copy-paste is not allowed and I am not sure how the insert-picture feature works (Source  is an open text field). Also attachment cannot be uploaded?

     

    Hope this reply give some more insight, thanks again for helping out!

    Bart

    • GilbertQ's avatar
      GilbertQ
      Super User
      5 years ago
      Hi there

      It would appear that your data source has to be used with a gateway based on your findings above.
      • BartdT's avatar
        BartdT
        Frequent Visitor
        5 years ago

        Hi, ok. Is there any way to find out why this is? Still wondering what makes this Web API different from my other ones and if there's any way to make it work. Anyone?