File.Contents function in Power Query

The File.Contents function returns the binary contents of the file located at a path.

Syntax

File.Contents(path as text, optional options as nullable record) as binary

Note: The path specified as the absolute path not as the relative path.

Example: Return the contents of the file as binary.

Power Query M

let
    Source = File.Contents("C:\Users\ashis\OneDrive\Desktop\New folder (18)\Ashish table.xlsx")
in
    Source

The output will be shown in the following image:

Note: The File.Contents function returns the binary content of the file.