New Feature Not Working: OPENROWSET with Onelake

[Nathan_Mosher]

OPENROWSET compatibility with Onelake was just announced as having been released today on the Fabric blog, but I cannot figure out how to get it to work. I use this regularly with ADLS storage with no issues.

I've tried copying their examples verbatim, or tried every alternate combination I can come up with, such as workspace name vs workspace id, URL from properties of file, lakehouse ID, lakehouse name, etc

I get an error: "has URL suffix which is not allowed" like it is still blocked by Microsoft. Does anyone know if this requires activating it in tenant settings to work?

https://blog.fabric.microsoft.com/en-us/blog/announcing-public-preview-onelake-as-a-source-for-copy-...

The documenation says the following should work:

SELECT *
FROM OPENROWSET(
    'https://onelake.dfs.fabric.microsoft.com/<workspaceId>/<lakehouseId>/Files/filename.csv'
);

It was just announced this morning, so they may have just announced it before actually releasing it. i'm not sure.

[Nathan_Mosher · Accepted solution]

UPDATE: It is working now. It just took a few days after the announcement.

[v-prasare]

Hi @Nathan_Mosher,

If your issue still persists, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support

[BalajiL]

Looks it is is not yet released in all the regions. Raise a ticket with Microsoft. 

[lbendlin]

most likely the release hasn't hit your cluster yet.  Keep trying for the next couple days, and if it still doesn't work, raise a ticket.