Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |