Copilot in Data Warehouse

[DavidPi]

We enabled Copilot on our P1 Capacity. We can use Copilot in Power BI reports (Service and Desktop), in Notebooks. But We do not see copilot in Data Warehouse. In Dataflow gen2 we see copilot icon - but error message.

I think there is only one way to enable copilot for Fabric. How is it possible to use copilot in PBI report, but not see it in warehouse and see error in dataflow (all object in the same workspace).

Thank you.

[Anonymous]

Hi @DavidPi ,

The F64 or P1 capacity needs to be located in one of the regions listed in the Enable Copilot in Fabric - Microsoft Fabric | Microsoft Learn article.

If your tenant or capacity is outside the US or France, Copilot is disabled by default unless your Fabric tenant admin enables the “Data sent to Azure OpenAI can be processed outside your tenant's geographic region, compliance boundary, or national cloud instance” tenant setting in the Fabric Admin portal.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[DavidPi]

Thank you, I know this. We can see and use Power BI Copilot, so I expect that these setings are enabled (I will check this with our admins). 

How is it possible that we see (can use) only Power BI Copilot and do not see other Copilots, like copilot for Data Warehouse, Dataflow, ... that is the question.

[Anonymous]

Hi @DavidPi ,

Open AI in Admin portal is a paid feature that requires communication with Azure when turned on.

May I ask if you have a free trial account? If so it may not be possible to use Copilot in warehouse.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[DavidPi]

We have Premium Capacity P1.

[Anonymous]

Hi @DavidPi ,

Please check these prerequisites:

• Your administrator needs to enable the tenant switch before you start using Copilot. For more information, see Copilot tenant settings.
• Your F64 or P1 capacity needs to be in one of the regions listed in this article, Fabric region availability.
• If your tenant or capacity is outside the US or France, Copilot is disabled by default unless your Fabric tenant admin enables the Data sent to Azure OpenAI can be processed outside your tenant's geographic region, compliance bound... tenant setting in the Fabric Admin portal.
• Copilot in Microsoft Fabric isn't supported on trial SKUs. Only paid SKUs (F64 or higher, or P1 or higher) are supported.

If you find that you meet these prerequisites, then you will be able to use Copilot in Power BI, but you will not be able to use Copilot in warehouse. The reason for this should be because "The Copilot in Fabric experiences for Data Factory, Data Engineering, Data Science, Data Warehouse, and Real-Time Intelligence are in preview. Data Science, Data Warehouse, and Real-Time Intelligence are in preview."

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[DavidPi]

As previously mentioned, we can utilize and view Copilot for Power BI, prerequisites are met. However, I am unclear about your statement, "...but you will not be able to use Copilot in warehouse."

Is this because Copilot in warehouse is currently in private preview?

Or is it due to the fact that it is in public preview and Copilot does not function with Premium Capacity, only with Fabric Capacity? Other Copilot features are also in preview, and while I can access them, they display errors, which is understandable given their preview status. However, the error messages are quite peculiar—for instance, the one we encounter with Dataflow.

In the same workspace we can use Power BI Copilot.....

[J00001]

Is this resolved on your end? The people replying to you are most likely bots as they CLEARLY fail to read your replies. You clearly stated it's working in Power BI but not in the Warehouse; this is your question, how is this possible? I am experiencing the same issue.
--I am an admin and OpenAI is enabled in my tenant
--my tenant is in a supported Region, using an F 64 in a supported region
--CoPilot works in PBI but is not visible in Warehouse; AI Services also work.

[DavidPi]

Hi,

The issue has not been resolved yet. I encountered a similar problem with Notebooks Copilot, which started working after 2-3 months.

My assumption was that the reason could be related to the preview stage of DWH Copilot or that we have P capacity instead of F capacity. However, since you have F capacity, it seems there may be another underlying issue.

It might be time to consider raising a support ticket for further assistance.

Best 

[Anonymous · Accepted solution]

Hi @DavidPi ,

Copilot in Fabric is currently in public preview and uses Fabric Capacity.

The error message indicates that your organization is not allowed to use Copilot in this workspace due to geolocation restrictions, is this condition met?

If so, this may be due to the preview state of the feature, and these limitations and errors should be resolved prior to full release.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!