Power BI does not recognize the attachment field of an ACCESS table

[yousseftb76]

Hello,

I have an ACCESS file where I feed a table of products and I have a field in said table type attachment where I attach the photo of the product in question.

When connecting Power BI to the ACCESS table, it recognizes all the fields in the table except the attached file field.

1- Is there any way for PowerBI to recognize the attachment field of ACCESS ?

2- If not, how can I feed ACCESS with images so that PowerBI recognizes them?

Thank you very much

[V-lianl-msft]

Hi @yousseftb76 ,

If you use a power bi desktop to connect to the Access database, the power bi desktop can not Identify the columns containing the attachments(jpg, pdf).

You can refer to this video as workaround:

https://www.youtube.com/watch?v=Q82yzcfkqAc 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/