Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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"
Are you able to connect data source from PBI Desktop ? What is the authentication method you used it to connect successfully in desktop ?
Proud to be a Super User!
yes. worked and conneted in power bi desktop using Anonymous
What is the privacy level set for data source in PBI Service. Make sure that it is set to 'none'.
Proud to be a Super User!