Refresh Web source through power bi server web portal

hana123 — Wed, 28 Dec 2022 07:39:33 GMT

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"

Re: Refresh Web source through power bi server web portal

FarhanAhmed — Wed, 28 Dec 2022 07:53:35 GMT

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

Re: Refresh Web source through power bi server web portal

hana123 — Wed, 28 Dec 2022 11:07:12 GMT

yes. worked and conneted in power bi desktop using Anonymous

Re: Refresh Web source through power bi server web portal

FarhanAhmed — Thu, 29 Dec 2022 03:45:15 GMT

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

topic Re: Refresh Web source through power bi server web portal in Report Server

Refresh Web source through power bi server web portal

Couldn't connect

Re: Refresh Web source through power bi server web portal

Re: Refresh Web source through power bi server web portal

Re: Refresh Web source through power bi server web portal