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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Can we really use WMS Map in Power BI?

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!

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

13 REPLIES 13
Brunner_BI
Super User
Super User

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

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

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

youngja_66_0-1698728533946.png

 

may you explain how, please?
tks

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

youngja_66_0-1708909672830.png

 

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_2-1708910311259.png

 

 

 

youngja_66_1-1708909951918.png

 

 

 

 

youngja_66
Frequent Visitor

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
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


ICON map visual allows WMS to be used.  

Anonymous
Not applicable

@PhilipTreacy  Thanks for the answer!

lbendlin
Super User
Super User

Please explain what WMS map is.

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
Not applicable

@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/

 

It's TopoJSON or bust...

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

youngja_66_0-1708909672830.png

 

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_2-1708910311259.png

 

 

 

youngja_66_1-1708909951918.png

 

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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