openrowset compatibility

[smpa01]

Is OPENROWSET compatible with lakehouse files?

E.g. the following does not work

select * 
from openrowset(
	BULK 'https://onelake.dfs.fabric.microsoft.com/ws/lakehouse_testing.Lakehouse/Files/read_test/2025-07-24T13:45:36.864628.parquet') as t

[BhaveshPatel]

Hi @smpa01 

You should convert parquet to delta file. This is the script.

sdf= spark.read.parquet("Crime-Data-Boston-2016.parquet")

sdf.write.mode("overwrite").format("delta").saveAsTable("DimXYZ")

[BalajiL]

@BhaveshPatel : There is a new feature in GA Openrowset to read the lakehouse files in sql endpoint.  No need to convert parquet to delta etc. We are discussion why Openrowset is not yet working. 

[v-ssriganesh]

Hello @smpa01,
Thank you for providing the error details. We recommend raising a Microsoft support ticket for further investigation. You can explain all the steps you have taken to help them better understand the issue.

You can create a Microsoft support ticket with the help of the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thank you for understanding.

[BalajiL]

@v-ssriganesh 

Though the feature is in GA, still unable to query , can you let me know what could be the issue. 

[v-ssriganesh]

Hello @BalajiL,
Thank you for your response and for providing the error details.

Based on the information and the screenshot you shared, the OPENROWSET function support with Lakehouse Parquet files in Microsoft Fabric is indicated to be in General Availability (GA) as of Q2 2025. This suggests that the feature should be supported across Fabric workspaces, including the ability to query files from the OneLake DFS path via the Lakehouse SQL endpoint.

The error message you encountered indicates a specific issue with the file path or its format. Here are some potential reasons and steps to resolve the issue:

• The error suggests that the URL contains a suffix that is not allowed. This could be due to the file being part of a partitioned dataset or having a naming convention that OPENROWSET does not yet fully support. Try querying a simpler file name to see if the issue persists.
• Verify the path is copied correctly from the Lakehouse UI using the "Copy Path" option. The path should match the format used in the successful example (e.g: https://msit-onelake.dfs.fabric.microsoft.com/<workspace-id>/<lakehouse-id>/Files/<filename>.parquet). Avoid manual edits that might introduce invalid characters or suffixes.
• Confirm you have the necessary permissions to access the file and execute queries in the Lakehouse SQL endpoint. Lack of permissions can sometimes manifest as unexpected errors.
  
  

Although the feature is marked as GA in Q2 2025, rollouts can sometimes be gradual across regions or workspaces. If the issue persists, it’s possible your region or workspace hasn’t yet received the full update. You can raise Microsoft Fabric support ticket to resolve the issue.

You can create a Microsoft support ticket with the help of the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Best Regards,
Ganesh singamshetty.

[smpa01]

@v-ssriganesh it does not work for me despite me being the admin

select * from
openrowset(
BULK 'https://onelake.dfs.fabric.microsoft.com/ws_id/lakehouse_id/Files/name_test/2025-07-24T15:14:18.681780.parquet'
) as t


Path 'https://onelake.dfs.fabric.microsoft.com/ws_id/lakehouse_id/Files/name_test/2025-07-24T15:14:18.681780.parquet' has URL suffix which is not allowed.

[BalajiL]

hi @v-ssriganesh 

It could be the roll out is pending and our workspace region belongs to 'Central India'. I ensured whatever you mentioned like copy path, file format, permission etc is correct. 

[v-ssriganesh]

Hello @BalajiL,
Thank you for the update.

Please consider reaching out to Microsoft Support. You can provide them with all the steps you've already taken, which will help them understand the issue better and provide a resolution. You can create a ticket with the help of following link: https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

[v-ssriganesh]

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.

[BalajiL]

hi @v-ssriganesh 

Can you please confirm from when onwards Fabric start supporting openrowset with lakehouse parquet file ? is it in GA.  It's not yet supported in our workspace. 

Running the query within the same lakehouse sql endpoint, provided correct path and file format etc. Not working to query files from sql endpoint.

11:52:56 AM Started executing on line 1
Msg 13832, Level 16, State 2, Line 1
Path 'https://onelake.dfs.fabric.microsoft.com/SynapseMigration/xxx.Lakehouse/Files/test/part-00000-081be3...' has URL suffix which is not allowed.
11:52:57 AM Query execution time: 00:00:00.002 | Time to process and render results: 00:00:01.206 | Total duration: 00:00:01.208