Forum Discussion

smpa01's avatar
smpa01
Community Champion
1 year ago

openrowset compatibility

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/File...
data engineering
Lakehouse
Notebook
BalajiL's avatar
BalajiL
Resolver I
1 year ago

v-ssriganesh 

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

 

 

v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

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.

  • BalajiL's avatar
    BalajiL
    Resolver I
    11 months ago

    HI v-ssriganesh 

     

    Thanks for your reply, just want to give an update on the issue. The issue is not related to any syntax/URL issue, the feature rolled out by MSFT in phased manner. It was available only for few regions initially and not available regions like Central India and etc. and it was confirmed by MSFT. Now the feature is available in Central India region as well.  Now I can able to query parquet files resides in onelake in sql end point using OPENROWSET.  Thanks for your reply. 

     

    • v-ssriganesh's avatar
      v-ssriganesh
      Community Support
      11 months ago

      Hello BalajiL,
      Thank you for your efforts and we're glad to hear your issue has been resolved. We appreciate you sharing your insights, as this will help other community members address similar issues more effectively.

  • BalajiL's avatar
    BalajiL
    Resolver I
    1 year ago

    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. 

  • smpa01's avatar
    smpa01
    Community Champion
    1 year ago

    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.