
Hello everyone,
I'm working on a project where I need to integrate document handling with data visualization in Power BI. Here's the workflow I'm trying to achieve:
Objective: Whenever a document is added or modified in a SharePoint document library, I want to convert this document into a Base64 string and save it as text within the same document library. The purpose is to retrieve this string into Power BI to display the content of the PDF document.
Challenge: The primary challenge I'm facing is the size of the Base64 strings. They range between 120,000 and 1,400,000 characters. Due to this size, the string must be segmented into smaller substrings and stored in different columns within the document library. Later, I plan to concatenate these substrings in Power BI to reconstruct the original string and display the PDF.