Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lmca
New Member

Custom WMS or WMTS Map Layer

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.

6 REPLIES 6
Anonymous
Not applicable

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=...)

 

2020-03-02_17-02-57.png

 

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"

 

ezgif.com-video-to-gif (3).gif

 

From there you can bring it into a map:

 

map from rest arcgis.png

v-cherch-msft
Employee
Employee

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.  

Anonymous
Not applicable

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.