openrowset compatibility

Hello smpa01,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I have reproduced your scenario in Microsoft Fabric by uploading a .parquet file to the Lakehouse and querying it using the OPENROWSET function via the Lakehouse SQL endpoint.

OPENROWSET now supports Lakehouse files using the OneLake DFS path, provided the query is executed from within Fabric (i.e., through the Lakehouse’s SQL Endpoint).

Example Tested:

SELECT *

FROM OPENROWSET(

    BULK ' https://msit-onelake.dfs.fabric.microsoft.com/297d2e15-e2ba-43af-b6c2-572ce32c262f/f4fd0d9a-231f-4e3b-970a-7848479bf0a8/Files/iris.parquet,

    FORMAT = 'PARQUET'

) AS t

Output was successfully returned from the Parquet file stored in Lakehouse:

If you're encountering errors, please ensure:

• You're running the query inside the SQL endpoint of the same Lakehouse in Fabric.
• The file path is correct (use Copy Path from the Lakehouse UI).
• You have appropriate permissions in that workspace.
• You're specifying the correct file format (e.g: 'PARQUET', 'CSV', etc.).

Best Regards,
Ganesh singamshetty.