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
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"