VikashRathee
9 years agoNew Member
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
Microsoft Employee
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 - Vicky_Song
Impactful Individual
Status changed:NewtoNeeds Info