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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
LisaHoffer
Regular Visitor

Turn an image into a report

I have an image that I would like to turn into a report. About 2 years ago when I attended a summit in Seattle, there was someone there that had an engine image (think it was a PDF) and turned it into a report indicating specific sections of the motor to associate with the reporting data (I think it was failure rates of the engine parts, but not sure). I would like to do something similar (just not with motors). I work for a home builder, and would like to use our community map to indicate what floorplans were built on which homesites and what stage of the building process they are in. At the moment, these community maps are being updated manually on a weekly basis, but the data I need to update the maps is coming out of PowerBI already...so if I can connect the two it would be great! I CANNOT do this on the mapping software as many of the addresses are non-existant yet because they are brand new streets. It typically takes 6 months for them to be mapped for GPS, and I can't wait that long.

 

If I can connect my current data in some way to my PDF maps, they will be updated automatically for us when all other reports are updated. Is there anyone that can tell me how to do this or point me in the right direction of where I can find the steps?

4 REPLIES 4
Gwigga
Frequent Visitor

You could try this one

 

2018-08-28_1201.png

Gwigga...this looks very promising. THANK YOU for suggesting Synoptic Panel. I'll check it out. Here is the example I mentioned in my original post about the engine example.

 

 

Sample.JPG

 

v-yuezhe-msft
Employee
Employee

@LisaHoffer,

You are able to display image by setting data category of an image column to Image URL, there is a similar thread for your reference.

However, it is not possible to extract data from image or PDF and use PDF/image as data source in Power BI. Some ideas about this issue have been submitted in Power BI ideas forum, please vote them up.

Support Pulling Images when using a webpage as a data connection
Allow PDF to be added to extract data

As a workaround for your issue, you can use online tools to extract data from PDF/image to file, then connect to file in Power BI Desktop.

https://docparser.com/blog/extract-data-from-pdf/
https://medium.com/@CharlesBordet/how-to-extract-and-clean-data-from-pdf-files-in-r-da11964e252e
https://automeris.io/WebPlotDigitizer/

Regards,
Lydia

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

Lydia, I appreciate the response, but neither of these links applies to what I am looking to do, nor am I trying to extract data from a PDF. I want to create a report (actually already have one) and use an image or PDF of one of our communities as the custom graphic showing different results from the report on the map. I finally found the "Engine Diagnostic" report on the Power BI site yesterday, but there is no information/steps on how to create something similar...and for some reason it will not allow me to include the image here. It just says you can create interactive reports customized for your business.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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