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