Problem with OPENROWSET BULK token

[fabric_user]

I'm following this training module:

https://learn.microsoft.com/en-us/training/modules/get-started-sql-database-microsoft-fabric/5-simpl...

When I'm trying to run this code, I'm getting an error:

SELECT TOP 100 *
FROM OPENROWSET 
(BULK 'abs://citydatacontainer@azureopendatastorage.blob.core.windows.net/Safety/Release/city=Seattle/*.parquet'
, FORMAT = 'PARQUET') 
AS [Seattle_Dataset]

I copy pasted the code directly from the tutorial:

Am I doing something wrong? 

I'm quite new to SQL databases

Thanks!

[Anonymous]

Hi @fabric_user 

Thanks for the solution JulianePadrao  and mohitkumawat  offered, the bulk can be used in Azure SQL instead of SQL Server.

You can refer to the following link about it.

Use BULK INSERT or OPENROWSET(BULK...) to import data to SQL Server - SQL Server | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohitkumawat]

Hi @fabric_user ,

as I checked in the Microsoft Doc right now "OPENROWSET" Features is not supported in SQL Fabric Database.

https://learn.microsoft.com/en-us/fabric/database/sql/feature-comparison-sql-database-fabric

[JulianePadrao]

Thank you for your feedback. It appears that this feature has been moved to the future roadmap. We appreciate you bringing this to our attention. The material has been updated accordingly and should be live soon.

[JulianePadrao]

We apologize for the inconvenience you experienced. The exercise has now been updated.

mslearn-fabric

[fabric_user]

Also the same error when trying to run this code:

https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/20-work-with-database.html?azur...