Forum Discussion

thyjones's avatar
thyjones
Helper I
5 years ago

Problem receiving data from web service

Good Afternoon,

 

I have a visual which basically conects to a web service, it is calling an API that returns a score. In Power BI Desktop, I can see this score fine, and it updates/changes accordingly. As soon as the report is published, all other metrics work but this one shows blank, even though there is a number.

 

I have concluded therefore for whatever reason the web service is blocking the request.

 

The API link basically is a customised link BUT a password etc is not required.

 

What I have noticed is, there is a gateway set to this web url, which maps to a datasource, this datasource set, with authenitication method anonymous, no privacy settings. I am not sure why this gateway is there, I am not sure if it was always there and has stopped working or has been added by accident (I don't think I need it), but, if i remove it, it breaks because it says the report is looking for a gateway.

 

Any ideas please?

Thanks

 

 

Dataflow
Need Help

6 Replies

  • collinq's avatar
    collinq
    Super User
    5 years ago

    HI thyjones ,

     

    If there are no data sources that are inside your organization then you do not need a gateway.  A gateway is only required if you are trying to reach into your organization.  If you do have the need for a gateway then you will have more than one data source in your report.

    If you do not need a gateway at all for this report and the report thinks it should be using a gateway, then go to datasets settings and select the "gateway connection" and turn off "Use a data gateway".  

    Let us know if that resolves it!

    • thyjones's avatar
      thyjones
      Helper I
      5 years ago

      Hi Collinq, thank you for such a quick reply.

       

      Now I do use a gateway for other bits, and this has been fine, so I need to keep the gateway, it is just that i don't think I need a gateway for this web/api request. How can I turn off just this one? As I say i deleted the datasource but it broke, and I only seem to have the option to point the gateway/web url to a datasource, but not delete it, if that make sense?

      • collinq's avatar
        collinq
        Super User
        5 years ago

        Hi thyjones ,

         

        I guess we should take a step back and go through the steps.  In the PBI Desktop file, you have more than one datasource, correct?  And, check the type of privacy level connection (Private, Organizational,etc) and then publish.

        In the Service check the Gateway itself to confirm that it is working (use the "test connection") and confirm that the Privacy Level for the gateway is the same as your report.

        In the Service, go to the Dataset and settings and then confirm that the Gateway Connection is set up appropriately for the report.  And, that there is no error message there either.

        Let us know if that resolves it.