Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Not able to update Datawarehouse Shortcut Table in Notebook

Hi All , I have created datawarehouse shortcut table in OneLake .When i m trying to update shortcut table in Notebook , getting below error. " User is not authorized to perform current operation...
data engineering
data warehouse
one lake
power bi
security
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    If the shortcut is pointing to a Fabric Warehouse table, then you cannot perform a DML operation on the table using SPARK, the allowed operations is Read operation. If you want to perform an update/DML operation either use TSQL or use CTAS to save the resultset/table in the Lakehouse. Please refer to the below link for more detail on the allowed operations.

    Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn

    Hope this is helpful. Please let me know incase of further queries.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Anonymous  Thanks

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

If the shortcut is pointing to a Fabric Warehouse table, then you cannot perform a DML operation on the table using SPARK, the allowed operations is Read operation. If you want to perform an update/DML operation either use TSQL or use CTAS to save the resultset/table in the Lakehouse. Please refer to the below link for more detail on the allowed operations.

Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please let me know incase of further queries.