Refresh Web source through power bi server web portal

[hana123]

Hi everyone. 

this is my query, i published the file on Power bi Web portal Server (on premisses ) 

in data source config, the error below showed: 

Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Unable to connect to the remote server

let

Source = Json.Document(
Web.BrowserContents(
"https://services6.arcgis.com",
[
RelativePath = "bKYAIlQgwHslVRaK/arcgis/rest/services/VWPlacesCasesHostedView/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json"]
)),
features = Source[features],
#"Converted to Table" = Table.FromList(features, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"attributes", "geometry"}, {"attributes", "geometry"}),
#"Removed Columns" = Table.RemoveColumns(#"Expanded Column1",{"geometry"}),
#"Expanded attributes" = Table.ExpandRecordColumn(#"Removed Columns", "attributes", {"PlaceName_AR", "PlaceName_EN", "GovernorateName_AR", "GovernorateName_EN", "RegionName_AR", "RegionName_EN", "PLC_CODE", "REG_CODE", "GOV_CODE", "Place_Category", "DataSource", "GlobalID", "OBJECTID_1", "Reportdt", "Name_Ar", "Name_Eng", "Place_Code", "Confirmed", "Deaths", "Recovered", "Tested", "NewAdded", "GlobalID_1587594607483", "ObjectId"}, {"PlaceName_AR", "PlaceName_EN", "GovernorateName_AR", "GovernorateName_EN", "RegionName_AR", "RegionName_EN", "PLC_CODE", "REG_CODE", "GOV_CODE", "Place_Category", "DataSource", "GlobalID", "OBJECTID_1", "Reportdt", "Name_Ar", "Name_Eng", "Place_Code", "Confirmed", "Deaths", "Recovered", "Tested", "NewAdded", "GlobalID_1587594607483", "ObjectId"}),
#"Added Custom" = Table.AddColumn(#"Expanded attributes", "Date", each DateTimeZone.ToLocal(DateTime.AddZone(#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Reportdt]/1000),0))),
#"Sorted Rows" = Table.Sort(#"Added Custom",{{"Date", Order.Descending}}),
#"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"Date", type date}})
in
#"Changed Type"

[FarhanAhmed]

Are you able to connect data source from PBI Desktop ? What is the authentication method you used it to connect successfully in desktop ?

[hana123]

yes. worked and conneted in power bi desktop using Anonymous

[FarhanAhmed]

What is the privacy level set for data source in PBI Service. Make sure that it is set to 'none'.