Streamlining Insights with Microsoft Copilot

Dive deeper into the world of AI innovation and stay ahead of the AI curve! Subscribe to our

Figure – The tenant settings from within Power BI

12. Ensure both settings are set to Enabled and then click on Apply.

Now that you have created your Fabric capacity, let’s jump into an example of how we can use Copilot to help with the cleaning of data. As we have created a new capacity, you will have to create a new workspace that uses this new capacity:

1. Navigate back to Workspaces using the left navigation bar. Then, select New Workspace.

2. Name your workspace CleaningData(Copilot), then select the dropdown for advanced configuration settings.

3. Ensure you have selected Fabric capacity in the license mode, which in turn will have selected your capacity below, and then select Apply. You have now created your capacity!

4. Now let’s use Fabric to create a new dataflow using the latest update of Datafl ow Gen2. Select New from within the workspace and then select More options.

5. This will navigate you to a page with all the possible actions to create items within your Fabric workspace. Under Data Factory, select Datafl ow Gen2.

6. This will load a Datafl ow Gen2 instance called Datafl ow 1. On the top row, you should now see the Copilot logo within the Home ribbon as highlighted:

streamlining-insights-with-microsoft-copilot-img-3

Figure – The results from asking Copilot to transform the data

To view the M query that Copilot has added, select Advanced editor, which will show the functions that Copilot has added for you:

streamlining-insights-with-microsoft-copilot-img-4

Figure – The resulting M query created by Copilot to carry out the request transformations to clean the data

In this example, you explored the new technologies available with Copilot and how they help to transform the data using tools such as Datafl ow Gen2.

While it’s great to understand the amazing possibilities AI brings to data, it’s also crucially important that you understand the challenges it presents.

Conclusion

In conclusion, Microsoft Copilot offers a groundbreaking approach to enhancing productivity and efficiency in data analysis and report generation within Power BI. By seamlessly integrating generative AI technology, Copilot revolutionizes the way insights are discovered and data is prepared, providing users with unprecedented speed and accuracy. Whether streamlining report creation or optimizing data management tasks, Copilot empowers users to unlock the full potential of their data, paving the way for more informed decision-making and actionable insights.

Author Bio

Gus Frazer is a seasoned Analytics Consultant focused on Business Intelligence solutions. With over 7 years of experience working for the two market-leading platforms, Power BI & Tableau, has amassed a wealth of knowledge and expertise. Gus has helped hundreds of customers to drive their digital and data transformations, scope data requirements, drive actionable insights, and most important of all, cleanse data ready for analysis. Most recently helping to set up, organize and run the Power BI UK community at Microsoft. He holds 6 Azure and Power BI certifications, including the PL-300 and DP-500 certifications. In this book, Gus offers readers invaluable guidance on ingesting, preparing, and cleansing data for analysis in Power BI. --This text refers to an out of print or unavailable edition of this title.