Can we really use WMS Map in Power BI?

[Anonymous]

Hi,

I am currently working with Power BI desktop and I want to use my WMS map as a referent layer.

I have tried ArcGIS Map for power bi but it seems forever loading.

I try to find information about using WMS map layer in Power BI but I am not able to find any information.

so, I just wonder that, can we really use WMS map with Power BI 

ps. my WMS Map is not table data.

Thanks in advance!

[Brunner_BI]

In the Icon Map custom visual you can use a WMS layer.

[youngja_66]

Yes, you need to have to raster/vector hosted on a server for WMS.  I just got it to work about 10mins abog

[mariofloripa]

may you explain how, please?
tks

[youngja_66]

I use ICON map visual.  Icon Map (icon-map.com)

WMS = Web Map Server.  You would need to be running this something like GeoServer.  Basically it is a spatial server that allow you to place raster/vector imagery on it.  When set up it then serves the files (e.g. geotiffs) as an image with a specific name/number.  You need to also create the symbology.

This is then used in the powerbi icon map visual.  In our case we have 8 rasters being used, and swapped based on relevant slicers etc.

We use a measure to do this

WMS base string (map type) = IF(SELECTEDVALUE('Spatial: Map display (slicer)'[ID])=1,"",SELECTEDVALUE('Spatial: WMS raster layers'[WMS base string]))

The WMS base string field in our case is the location of the WMS server (https:///etc.etc)

The WMS layer name corresponds to the unique number given to each raster image

[youngja_66]

I think? the way ArcGis visual works, is that it actually downloads the data first.  And this everytime you refresh the pbi.  Hence the slowness.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

No, WMS maps are not supported in PBI

How to Create and Use Maps in Power BI (Ultimate Guide) (spreadsheeto.com)

Regards

Phil

[youngja_66]

ICON map visual allows WMS to be used.  

[Anonymous]

@PhilipTreacy  Thanks for the answer!

[lbendlin]

Please explain what WMS map is.

[youngja_66]

WMS is as a Web Map Service.  i.e. a vector or raster is hosted on a mapping service.  Not unlike a html page being hosted on a web service.

In our case in the dashboard we use ICON map visual.  The raster images (esri format geotiffs) are loaded to a web map service (server in our department, linked to the outside world).  You need to also provide symbology.  Basically the files are stored on the server and returned back as an image with the symbology.  Each file is given as specific url, and layer identity to be able to view that specific file.  

[Anonymous]

@lbendlin  WMS is a kind of map that you can access through URL

I am not sure if this link could explain it better https://lpdaac.usgs.gov/tools/web-map-service-wms/

[lbendlin]

It's TopoJSON or bust...

[youngja_66]

I use ICON map visual.  Icon Map (icon-map.com)

WMS = Web Map Server.  You would need to be running this something like GeoServer.  Basically it is a spatial server that allow you to place raster/vector imagery on it.  When set up it then serves the files (e.g. geotiffs) as an image with a specific name/number.  You need to also create the symbology.

This is then used in the powerbi icon map visual.  In our case we have 8 rasters being used, and swapped based on relevant slicers etc.

We use a measure to do this

WMS base string (map type) = IF(SELECTEDVALUE('Spatial: Map display (slicer)'[ID])=1,"",SELECTEDVALUE('Spatial: WMS raster layers'[WMS base string]))

The WMS base string field in our case is the location of the WMS server (https:///etc.etc)

The WMS layer name corresponds to the unique number given to each raster image