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 ,

 

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!

 

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi thyjones 

    Please check how did you connect to your data source, by Web.BrowserContents or Web.Contents?

    Did you use Booleans in your filters?

    I found an issue like yours, I hope it could help you.

    Issue: Visualization BLANK after refreshing page in Power BI service

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

    • thyjones's avatar
      thyjones
      Helper I
      5 years ago

      Hi RicoZhou,

       

      To answer your questions:

      = Web.BrowserContents("https://app.website.com/api.php?apiKey=abcdef&getMethod=getNPSValue" & "&fromDate=2020-12-01" & "&toDate=2020-12-31")

       

      I don't use booleans as far as I know, this is my process:

       

      let
      Source = Web.BrowserContents("https://app.website.com/api.php?apiKey=abcdef&getMethod=getNPSValue" & "&fromDate=2020-12-01" & "&toDate=2020-12-31"),
      #"Converted to Table" = #table(1, {{Source}}),
      #"Replaced Value" = Table.ReplaceValue(#"Converted to Table","<html><head></head><body>","",Replacer.ReplaceText,{"Column1"}),
      #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","</body></html>","",Replacer.ReplaceText,{"Column1"}),
      #"Renamed Columns" = Table.RenameColumns(#"Replaced Value1",{{"Column1", "NPS"}}),
      #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"NPS", Int64.Type}})
      in
      #"Changed Type"