Forum Discussion
Refresh Web source through power bi server web portal
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"
3 Replies
- FarhanAhmedCommunity Champion
Are you able to connect data source from PBI Desktop ? What is the authentication method you used it to connect successfully in desktop ?
- hana123Frequent Visitor
yes. worked and conneted in power bi desktop using Anonymous
- FarhanAhmedCommunity Champion
What is the privacy level set for data source in PBI Service. Make sure that it is set to 'none'.