powerbi.com can't refresh the public web data while desktop app is doing that successfully

[VikashRathee]

My public data source(JSON) from our website : https://cdn.datascraping.co/reports/sample-data.txt

Error in refresh : 

 

I created the report from Desktop app and refresh is working fine there but not on powerbi.com

let
    Source = Json.Document(Web.Contents("https://cdn.datascraping.co/reports/sample-data.txt")),
    result = Source[result],
    #"Converted to Table" = Table.FromList(result, Splitter.SplitByNothing(), 
null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", 
{"account_id", "account_status", "created_on", "active_plan", "trial_expired_on"}, 
{"Column1.account_id", "Column1.account_status", "Column1.created_on", 
"Column1.active_plan", "Column1.trial_expired_on"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",
{{"Column1.trial_expired_on", type date}, {"Column1.created_on", type date}})
in
    #"Changed Type"

This is the sample static file as data source I created to put on public forum here. Actually, we were connecting from our web api with key in http get as querystring which is also failing to refresh on powerbi.com but working on desktop without any issue.

For example : https://api.datascraping.co/v1/test-endpoint?key=some-key-here

Thanks

[v-haibl-msft]

@VikashRathee

In Power BI Service, have you edited the credential in Dataset settings? I tried on my side and it can be refreshed successfully both in Desktop and Service.

Best Regards,
Herbert