Hi @MKingdon
Just adding to @tharunkumarRTK 's answer, in casea you are still looking at this.
I have been experimenting with a Power BI model/report that takes a folder of JPG files (each of which should have EXIF GPS tags), and uses Power Query to:
- Extract the latitude/longitude values
- Load the image data in Base64 format.
My PBIX and some test images are attached in a ZIP file.
In order to work, this does require images to be not too large (my estimate is up to 1.5 MB but will require some testing), since each image is represented using Base64 text and there are limits to the size of the text value that represents the image in the report. During testing, I had to reduce the size of some images to make it work.
If you want to use external URLs for images, they generally need to be anonymously accessible, which can be a problem if the images are sensitive.
I have attached my working PBIX in case it's of use to you.
- The PBIX is pre-loaded with some test images (photos of various cities).
- You can change the Folder parameter to your own folder containing geotagged JPGs and refresh (Transform Data > Edit Parameters).
- The model contains two tables (extracts shown below):
- Image: One row per image containing ID, filename & lat/long.
- Image Data: Contains JPG data for each image split across rows in Base64 format.
- The two key functions in Power Query which you should take a look at are:
- fnJpgGPS: Takes JPEG binary data as an argument and returns a record in the form [Latitude = LatitudeDecimal, Longitude = LongitudeDecimal]
- fnJpgSpliBase64: Takes JPEG binary data and "size" as arguments, and returns a table with the Base64 representation of the file split across indexed rows. Size should be at most around 30,000 (see this blog post from Chris Webb).
- These functions are used to generate the Image & Image Data tables.
- You can then use various map visuals to plot the locations, and visuals such as HTML Content or HTML Content (lite) to display the images themselves. A sample report page with a map and a Card (new) visual is shown below.
If you need to customize the basemap itself, I'm sure this is possible with Icon Map or other visuals, though I haven't tried it yet.
Hope this is of some use!
Hi @MKingdon
Just adding to @tharunkumarRTK 's answer, in casea you are still looking at this.
I have been experimenting with a Power BI model/report that takes a folder of JPG files (each of which should have EXIF GPS tags), and uses Power Query to:
- Extract the latitude/longitude values
- Load the image data in Base64 format.
My PBIX and some test images are attached in a ZIP file.
In order to work, this does require images to be not too large (my estimate is up to 1.5 MB but will require some testing), since each image is represented using Base64 text and there are limits to the size of the text value that represents the image in the report. During testing, I had to reduce the size of some images to make it work.
If you want to use external URLs for images, they generally need to be anonymously accessible, which can be a problem if the images are sensitive.
I have attached my working PBIX in case it's of use to you.
- The PBIX is pre-loaded with some test images (photos of various cities).
- You can change the Folder parameter to your own folder containing geotagged JPGs and refresh (Transform Data > Edit Parameters).
- The model contains two tables (extracts shown below):
- Image: One row per image containing ID, filename & lat/long.
- Image Data: Contains JPG data for each image split across rows in Base64 format.
- The two key functions in Power Query which you should take a look at are:
- fnJpgGPS: Takes JPEG binary data as an argument and returns a record in the form [Latitude = LatitudeDecimal, Longitude = LongitudeDecimal]
- fnJpgSpliBase64: Takes JPEG binary data and "size" as arguments, and returns a table with the Base64 representation of the file split across indexed rows. Size should be at most around 30,000 (see this blog post from Chris Webb).
- These functions are used to generate the Image & Image Data tables.
- You can then use various map visuals to plot the locations, and visuals such as HTML Content or HTML Content (lite) to display the images themselves. A sample report page with a map and a Card (new) visual is shown below.
If you need to customize the basemap itself, I'm sure this is possible with Icon Map or other visuals, though I haven't tried it yet.
Hope this is of some use!
I would suggest you to save all your images in a storage folder (for example sharepoint folder). We would need some identifier to identify the geo location of each image, so my recommendation is put the image name as the respective latitude and longitude. Load those images and their names (Image URL or binary code of the images) into Power BI. Map. Then you will be able to plot the locations with the latitude and longitude data.
After that in a new page, add a table and put the image URL column (Do not forget to categorize the image column as Image URL column). Then convert this page as drill through page and put the latitude and longitude fields as drill through fields.
This way you will be able to create a map visual in Power Bi and your end users can see the image when they right click on drill through on a specific location.
If you want your user to see the image when they hover over a location then instead of making it as drill through page you can set it as tooltip page.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
