Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I would like to display a map that contains my own custom map layer - either WMS or WMTS. I have tried the standard Map, Arcgis and Mapbox, but could not find anywhere to add my own layer. Is this possible out of the box or am I going to have to write something? Thanks.
I know this is some what old but you can do this by using the Query tool that is a part of ArcGIS Rest services.
For example if you create a query like this and grab the json version (https://idpgis.ncep.noaa.gov/arcgis/rest/services/NWS/USGS_Stream_Gauges/MapServer/0/query?geometry=...)
You can bring it into Power BI using the following query into a Blank Query (under New Source):
let
url = "https://idpgis.ncep.noaa.gov/arcgis/rest/services/NWS/USGS_Stream_Gauges/MapServer/0/query?geometry=-80.549980,35.326907&geometryType=esriGeometryPoint&inSR=4326&distance=50 &units=esriSRUnit_StatuteMile&outFields=*&returnGeometry=true&f=pjson",
Source = Json.Document(Web.Contents(url)),
response = Source[features],
#"Converted to Table" = Table.FromList(response, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"attributes"}, {"Column1.attributes"}),
#"Expanded Column1.attributes" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.attributes", {"OBJECTID_1", "OBJECTID", "feature_id", "site_no", "site_name", "da_sqkm", "lat", "lon"}, {"Column1.attributes.OBJECTID_1", "Column1.attributes.OBJECTID", "Column1.attributes.feature_id", "Column1.attributes.site_no", "Column1.attributes.site_name", "Column1.attributes.da_sqkm", "Column1.attributes.lat", "Column1.attributes.lon"})
in
#"Expanded Column1.attributes"
From there you can bring it into a map:
Hi @lmca
Please check if below posts could help.
https://community.powerbi.com/t5/Desktop/Create-Your-Own-Custom-Map-for-Power-BI/td-p/165854
https://community.powerbi.com/t5/Desktop/Creating-Map-layer/td-p/356864
Regards,
Thanks for the reply. Unfortunately this is not quite what I want. We have published our own basemap for New Zealand as WMTS (Web mapping tile service) or WMS and would like to use it as a base map rather than any of the default ones provided. We use it for our own mapping applications (eg. Leaflet) and have several clients asking if they can use it with PowerBI.
Hi, I am just wondering if you have managed to work this out as I have the same need - to laod a wms or wmts map into the system without going through ARCGis.
Hola, para ver una capa publicada en arcgis server en power bi deberá usar ArcGIS Mapas for Power Bi
Sorry @Anonymous I never found a way - although I also didn't spend that long on it. If you do though please please let me know!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |