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
yaseenhamid
Frequent Visitor

Error while importing photos from local folders (help)

Hi. I have 1 folder (named power bi villas photos photos).  It further contains 2 folders (named 16 Mar 2023 and 6 May 2023).  These 2 subfolders have photos that I'm trying to import (3.jpeg etc) .  Power bi imports the folder path in a column, from which I'm extracting dates (I.e 16 march 2023 and 6 May 2023).  But during last step when I try to expand the content column it shows error 'we didn't recognize the format of your first file (3.jpeg). Please filter the list of files...' 

 

WhatsApp Image 2023-05-09 at 11.01.16 AM.jpegWhatsApp Image 2023-05-09 at 11.01.16 AM (1).jpegWhatsApp Image 2023-05-09 at 11.01.15 AM.jpegWhatsApp Image 2023-05-09 at 11.01.15 AM (1).jpegWhatsApp Image 2023-05-09 at 11.01.14 AM.jpeg

3 REPLIES 3
AnastasiaS
Resolver I
Resolver I

Hello @yaseenhamid 

 

Indeed the combine feature works with only specific datasources like text, excel, csv files, workbooks... In your case I suppose that you only need to get the "image" from those files and be able to use it in your reports.

 

Check this article from Chris Webb where he explains step-by-step how to do it : https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/ 

 

There is a shorter way with just concatenating the "data:image/jpeg;base64 ," to the binary content, but if your image is large this could not work properly. You'll have a cropped image. This is why I suggest to directly check Chris' article where he shows how to manage larger files. There is still a limit of size, so it depends on your files.

 

Tell me if that works!

Regards,

 

 

I want to use a date slicer with it. And filter dates which are in 6 May 2023 folder and so on. 

Sure, if your folder is always named as following, "dd-mmm-yyyy" you can just duplicate your FolderPath.9 column, rename it as "Reference date" for example:

AnastasiaS_0-1683627738504.png

 

and change its type to Date:

AnastasiaS_1-1683627754003.png

-> 

AnastasiaS_2-1683627768921.png

 

It should normally work as expected and transform your column to date type.

Then, you'll be able to use it to filter data.

 

Hope I understood well your question.

 

And then, if you want to use the images in a visual like table for example, you can use the steps from the mentioned article.

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.