cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alex93jansen
Helper II
Helper II

In which table/entity are email attachments stored (Base64)?

We recently did an export of all tables in our Dataverse environment to create a backup of old Dynamics 365 data in SQL. However, we are struggling to locate the table that stores the actual Base64 of the email attachments/images that can be decoded. The only thing we have found thus far are attachment GUIDs which aren't useful by themselves.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @alex93jansen@dpoggemann,

There are different types of storage in Dataverse.

The storage SAS link @alex93jansen provided is to retreive data form DataLake if Dataverse is exporting to DataLake which is completly different.

Hope this helps!

View solution in original post

5 REPLIES 5
dpoggemann
Super User
Super User

Hi @alex93jansen ,

 

Please review the following:  https://docs.microsoft.com/en-us/power-platform/admin/capacity-storage#summary-tab

The tables used for storage of the attachments are identified here.

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
alex93jansen
Helper II
Helper II

So if I understand correctly, the actual attachment files are stored in the File Storage, and tables use GUIDs to reference the files.

 

I followed this tutorial to access the File Storage, but it returns empty (no errors, no folders or files) https://docs.microsoft.com/en-us/power-platform/admin/storage-sas-token

 

dpoggemann
Super User
Super User

Hi @alex93jansen ,

 

The files are still stored in tables from my understanding, space for these specific areas are calculated as File storage by Microsoft.  See list below.  The Attachment table is the key table utilized to store attachments.  @EricRegnier , any feedback or differences from your background on this one...

 

SUMMARY TAB
Number Description
(1) Storage capacity usage
  • File and database: The following tables store data in file and database storage:
    • Attachment
    • AnnotationBase
    • Any custom or out-of-the-box table that has columns of datatype file or image (full size)
    • Any table that is used by one or more installed Insights applications and ends in - Analytics
    • WebResourceBase
    • RibbonClientMetadataBase
  • Log: The following tables are used:
    • AuditBase
    • PlugInTraceLogBase
  • Database only: All other tables are counted for your database including the Dataverse search index
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Hi @alex93jansen@dpoggemann,

There are different types of storage in Dataverse.

The storage SAS link @alex93jansen provided is to retreive data form DataLake if Dataverse is exporting to DataLake which is completly different.

Hope this helps!

Thanks @EricRegnier and @dpoggemann I was able to retrieve the email attachments from that table by using Power Automate.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,345)