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 accordi...
Dataflow
Need Help
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.

       

      • thyjones's avatar
        thyjones
        Helper I
        5 years ago

        Thanks for your input again.

         

        So, in PowerBI desktop, I've checked the data source settings for the query, set to Anonymous and privacy level none.

         

        I've checked the Gateway clusters and under the gateway ive checked the data source, which is set to authentication method Anonymouse an privacy level none. It also shows Connection Successful. The gateway appears to be working fine.

         

        I can manually and with scheduled refresh, refresh the dataset, and there is no issue.

         

        I've changed from say anonymous to web api, and back to different settings in case something was wrong, and strangely it worked temporarily (the figure I am expecting popped up on the report), but i refreshed the report and it has gone back to being blank..

         

        Confused!