Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Copilot in MGD in Fabric Dataflow Gen2 empowers you to ingest and transform data effortlessly with natural language commands. Discover a faster, smarter way to get the data you need.
- Easily ingest data from your recently used tables by choosing from the recent tables list.
- Chat with your data to apply transformations to find the data you want.
Prerequisites
The following prerequisites are required before you start:
- A Microsoft Fabric tenant account with a subscription which is at least an F2 or P1 SKU: Fabric Copilot Capacity.
- Make sure you have a Microsoft Fabric enabled Workspace: Create a workspace.
- Create a new Dataflow if you don’t have an existing one and ingest some data by taking reference on Create your first dataflow and ingest data.
Chat with Copilot in Modern Get Data
In Fabric Dataflow Gen2, click Get data to begin. In the Get Data wizard, click the Copilot tab, then you can start with the list of recently used tables. You can either choose the recently used tables in the get started module or choose recent tables from the "Choose context" in the chat box.
After loading the recently used table, you can chat with Copilot to find the data you want. For step-by-step exploration, we want to first group by the data on customers' titles to check the results. Then depending on the range of the counts, we can decide to include which ranges.
When selecting table columns, use @ to quickly view available columns. Then entering the letter can filter on detail column.
If you know all the operations you want to do in the beginning, you can describe all in one sentence. Then Copilot can quickly understand it and provide the filtered results to you.
To return to the previous step, click the Restore button next to it and your data will revert to that point. You can also Copy the preview data to confirm with your colleagues before saving it into Dataflow Gen2.
