Forum Discussion
Cannot add column to table in Power Query because "Database is in restricted mode"
I imported a table of data into Power Query but cannot create a new column. When I try to split the column or do any transformation, I get this error message: DataSource.Error: Microsoft SQL: Dat...
studentofdata , I doubt this table is in direct query mode ,
check https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
Hi amitchandak,
Thank you for your help.
The storage mode of my tables already says "Import". Is there anything else I should do?