Microsoft Fabric introduced the concept of Dataflows (Gen 2) to the general public. Fabric Dataflows enable users to access and leverage data from different environments and sources in a low/no code way within Fabric. Sounds awesome, right? How can we get started?

Using the familiar Power Query authoring experience, we can extract, transform, and load data into different places within Fabric, depending on our use cases. We will explain the basic architectural components to give you a solid foundation, and then we will explore some actual use cases within the solutions you might be building. We will also highlight some potential pitfalls that might affect your experience.

Fabric Dataflows have an audience of business users in mind who want to work with their data in a seamless way, though they also offer some interesting capabilities for more experienced Data Engineers. We will show how business users can play a vital role in helping to build out those elusive Enterprise Data Platforms and Models in a co-creating method.

Finally, we'll discuss how you can integrate these Dataflows into your overall structure for refreshing the data, to make sure they are processed at the right time, to the right place.