Forum Discussion
Copilot using capacity despite not being active
Some days ago I clicked a copilot button somewhere. I think it might have been query generation in the SQL endpoint of a lakehouse. Now, we have an F4 capacity, so Copilot is not available. In line with this I can't remember anything of note happening after clicking the button. However, several Copilot processes thereafter showed up as consuming quite a considerable amount of capacity.
Has this happened to anyone else? It seems unfair to me to be able to spend capacity on (unavailable) Copilot without any benefit.
Hi NotebookEnjoyer ,
since May, copilot features are available for all F SKUs and not only for F64 and higher.
We have experienced that some copilot features are now enabled by default and could therefore consume resources. For instance, both Fabric warehouse and SQL database items inherit a copilot auto complete capability which might be turned on by default now since it is available for your capacity.
You can check this by navigating to Settings --> Copilot --> Show Copilot completions and see if the toggle is turned on.
Hope this helps! 🙂
I see. Can confirm that it does not seem possible to disable code completion for a SQL endpoint since the option doesn't exist in the lakehouse settings.
What's possible is to disable copilot features on tenant/capacity level as specified in the documentation . This of course requires according user privileges. This will help you control your capacity usage in the short term.
Will be curious to see if other users face similar problems and if there is a way to disable auto completions on lakehouse level in a way that we are currently missing. 🙂
9 Replies
- ObungiNiels
Resolver III
Hi NotebookEnjoyer ,
since May, copilot features are available for all F SKUs and not only for F64 and higher.
We have experienced that some copilot features are now enabled by default and could therefore consume resources. For instance, both Fabric warehouse and SQL database items inherit a copilot auto complete capability which might be turned on by default now since it is available for your capacity.
You can check this by navigating to Settings --> Copilot --> Show Copilot completions and see if the toggle is turned on.
Hope this helps! 🙂
- NotebookEnjoyer
Advocate II
Spot on, it's the warehouse. In hindsight this was rather obvious, as this was also the space in which the correspondent capacity load was allocated. However: The promised button in the warehouse settings is absent?
I guess I must be tenant admin or something like that?- ObungiNiels
Resolver III
You do not need to be tenant admin. I can see the button as member. However, from the looks of your screenshot, you might have navigated to the settings of a SQL analytics endpoint of a lakehouse rather than to a warehouse. Might that be the case?
For me, it looks like this:
- suparnababu8
Super User
Even though if you have Capacity license, your Fabric admin should enable to use Co-pilot feature in Admin settings. Please check that.
Thanks!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!