Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Base-64 string error
Small and medium business | Business Central, N...
Suggested answer

Base-64 string error

(2) ShareShare
ReportReport
Posted on by CU15040948-0 14
Re-formatted data in excel sheet to text, there are no Blob or image fields, however, there is still this error
Categories:
Dynamics 365 Business Central
Screenshot 2025-0...
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 16,386 Super User 2025 Season 1 on at
    Base-64 string error
    You're getting the error because Business Central is trying to decode a Base-64 string, but the input contains invalid characters—this usually happens when a field is expected to contain a Blob or Media (which requires proper Base-64 encoding), but you're importing plain or malformed text instead.
    Even if your Excel sheet has only text, a field might still be mapped to a binary type, or there may be hidden characters, formatting, or corruption in the data. To fix it, check your import mapping for any Blob or Media fields, clean the Excel data by copying it into Notepad and back to strip hidden formatting, and ensure no fields contain invalid characters for Base-64.
     
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 4,495 on at
    Base-64 string error

    Hidden Characters or Formatting: Even if cells look like text, Excel may include hidden formatting or non-printable characters. Fix: Save the file as CSV UTF-8 (Comma delimited) and open it in a plain text editor (like Notepad++)

    Use the "Validate" action in the Configuration Package before applying data. It can point out issues line by line.

    Thanks, Ramesh

    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

     
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,085 on at
    Base-64 string error
    Good morning, afternoon, or evening depending on your location!
     
    The Base-64 string error in your Excel sheet might occur due to hidden or unexpected data formats, even if there are no Blob or image fields.
    Possible Causes:
    1. Hidden Base-64 Encoded Data:
      • There might be hidden Base-64 encoded strings in the Excel sheet that are not visible in the text format.
      • These could be remnants of previous operations or embedded objects.
    2. Formatting Issues:
      • The re-formatting process might not have fully converted all fields to plain text, leaving some data in Base-64 format.
    3. External References:
      • The sheet might contain links or references to external files that include Base-64 encoded data.
    Solutions:
    1. Inspect the Data:
      • Use Excel's Find and Replace feature to search for patterns like data:image/png;base64 or other Base-64 prefixes.
      • Check for hidden rows, columns, or sheets that might contain encoded data.
    2. Clear Formatting:
      • Select all cells and use the Clear Formats option to ensure all data is plain text.
    3. Export and Re-import:
      • Export the sheet to a CSV file and re-import it into Excel. This process can strip out hidden formatting and embedded objects.
    4. Check for Macros or Scripts:
      • If the sheet uses VBA macros or scripts, review the code for any operations involving Base-64 encoding.
    5. Use Data Validation:
      • Apply data validation rules to ensure that only plain text is entered in the relevant fields.
     
    Hope this is helpful :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,065

#2
YUN ZHU Profile Picture

YUN ZHU 1,004 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 830

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans