Analytics Engineering with Microsoft Fabric and Power BI

Chapter 6. Working with the Lakehouse in Microsoft Fabric

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the authors’ raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 6th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you’d like to be actively involved in reviewing and commenting on this draft, please reach out to the editor at [e-mail].

The lakehouse is not just where your data lives - it’s where your data comes alive.

When Microsoft announced Fabric and its lakehouse capabilities, many of us in the data community had the same reaction: Oh great, another lakehouse implementation. Just what we needed. We’d been burned before by promises of “ground-breaking” data solutions that would solve all our problems. Remember when data lakes were going to replace everything, as we discussed in Chapter 2? Yes, that worked out well – we all got nice data swamps to manage.

After spending considerable time working with the Fabric lakehouse, we can assure you that this isn’t just another vendor slapping lakehouse on their existing tech stack. Microsoft has done something genuinely clever here. They’ve taken the lakehouse concept we discussed in Chapter 2 and woven it into a unified analytics platform in a way that actually makes sense.

Think of it like this: imagine you’re renovating ...