Forum Discussion
Unable to save SQL query as VIEW
Hi erkuiper - Thanks for using Fabric Community,
We have an update from internal team -
"Apologies for the inconvenience that you are experiencing. This error is due to an issue that the team is working on and we don't allow users to write when schema is set to INFORMATION_SCHEMA."
While doing repro we were able to create/save the view when schema is dbo.
We tested this and it works fine without any error for me and my team.
In your case If you still facing the issue - "Unable to save the view when schema is dbo", I would recommend to raise a support ticket so that an engineer can take a closer look at it.
erkuiper - Thanks for your response.
I will also address this issue with internal team.
I will update you once I hear from them.
Appreciate your patience.
Hi erkuiper - Thanks for using Fabric Community,
We have an update from internal team -
"Apologies for the inconvenience that you are experiencing. This error is due to an issue that the team is working on and we don't allow users to write when schema is set to INFORMATION_SCHEMA."
While doing repro we were able to create/save the view when schema is dbo.
We tested this and it works fine without any error for me and my team.
In your case If you still facing the issue - "Unable to save the view when schema is dbo", I would recommend to raise a support ticket so that an engineer can take a closer look at it.