VikashRathee's avatar
VikashRathee
New Member
9 years ago
Status:
Needs Info

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

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

2 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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