Access lakehouse using logic app via Managed Identity

Hi Anonymous,

Currently, when you use an HTTP GET request to the Lakehouse endpoint to read a file like .xlsx, the response is not automatically treated as binary in Logic Apps. It gets interpreted as text, which corrupts binary formats like Excel, images, PDFs, etc. So even though the file appears to download, it’s unreadable because it was never preserved in raw binary during transfer.

In Logic Apps, you can use "base64(body('HTTP'))" to convert the output to base64 or if you're passing it to another action (like SharePoint or Blob), map the raw body directly into the File Content field without converting to string/text.

For SharePoint or Blob target make sure the “File Content” field accepts base64/binary directly (depending on the connector). And in Blob storage, use "Create Blob" or "Upload Blob" with Content as body('HTTP').

And if you're using the SharePoint connector in the "Create file" or "Update file" actions, set File Content as "base64ToBinary(body('HTTP'))", if the connector expects binary input.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.