Fundamentals of Microsoft Fabric

Chapter 13. AI and Copilots

“Hey, Copilot, can you summarize this book for me?”

We sincerely hope you won’t write a prompt like this, since we firmly believe you should read our book in full. However, we won’t blame you much (just kidding, of course we will) if you leverage the latest technology to save yourself some time and effort. As you well know, we can’t deny the omnipresence of artificial intelligence (AI) and large language models (LLMs) in every segment of our lives.

In this chapter, we will examine how AI and LLMs can be leveraged in various Microsoft Fabric components, as well as in which scenarios you might consider asking Copilot for assistance. We have to be honest at the very beginning and warn you that this is going to be quite a long chapter—but this is not to scare you off from reading it! On the contrary, we want to assure you that you should expect a thorough overview of the AI features and Copilots in Microsoft Fabric.

Before we dive into exploring various implementations of AI in Microsoft Fabric, let’s first take a step back and examine LLMs, as they represent the backbone of Copilot, which we cover in depth in the next section. If we had written this book just two years ago, this chapter almost surely wouldn’t have existed. But as of today, it’s unthinkable to write practically any tech book without mentioning LLMs. That is how rapidly this new technology has risen to prominence.

In plain English, an LLM is the software that can “talk” to you using natural ...