Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText('i45WOrRAodohyD/csCagKD8rNbmkxtPUwMCgJszQKCYPKAmTNwKJAJGhkZmjaQ1QQUpiSWpNSWZuKkxZba1SbCwA', BinaryEncoding.Base64), Compression. The steps generate the following code in Advanced Editor, you can copy it and paste it to the Advanced Editor of a blank query to test the process. Click 'Submit' button to start processing. Select an extraction type from: text, images, fonts and attachments. You can also click the dropdown button to choose online file from URL, Google Drive or Dropbox. Secondly, does the data that you want to extract exist in a single field? If so, you can perform a series of steps(split column, remove columns, merge columns ) in Query Editor to extract data. Click 'Choose Files' button to select multiple PDF files on your computer. And you can click Refresh button in Power BI Desktop every 5 min to get updated data. The extracted text will be added to a property called. Do you put all the text files in a specific folder? If so, use Folder connector in Power BI Desktop to connect to your source and you can import all text files from the folder. Once installed, this module will extract text from files to make them searchable and machine readable.
