You're reading from Expert Data Modeling with Power BI - Second Edition

Product typeBook

Published inApr 2023

PublisherPackt

ISBN-139781803246246

Edition2nd Edition

Concepts

Business Intelligence

Author (1)

Soheil Bakhshi

Introduction to Dataflows

In the previous chapter, we learned some more advanced data modeling techniques that are more related to data warehousing: dealing with SCDs and degenerate dimensions. This chapter briefly introduces Dataflows, another available feature in the Power BI platform that can become handy in real-world scenarios. To get the best out of Dataflows, we need to pay attention to numerous technicalities that directly impact our design and implementation, such as the storage mechanism and licensing details making it virtually impossible to cover all in a single chapter. So, this chapter is designed to cover the basics and help you to build robust building blocks for your learning journeys. This chapter covers the following areas:

Scenarios for using Dataflows
Dataflow terminology
Create Dataflows
Export/import Dataflows
No-code/low-code experience in Dataflows
Introduction to composite models
Query plans in Dataflows

Introduction to Dataflows

In November 2018, Microsoft released Dataflows in public preview. Later on, in April 2019, Dataflows became generally available. Dataflows used to be available in Premium licenses only, but it is now available in Power BI Pro with some limitations. The purpose of Dataflows is to support collaborative self-service data preparation and Extract, Transform, and Load (ETL) processes in an organization by leveraging the power of Power Query in the cloud. The Dataflows technology is also known as Power Query Online. The Dataflows technology is available in Power Platform either in Power BI or Power Apps. The Dataflows store the prepared data in standardized files and folders format known as the Common Data Model (CDM) folder. If created in Power Apps, the resulting tables can be stored in Dataverse or an Azure Data Lake Storage Gen2 (ADLS Gen 2). The Power BI Dataflows, however, store the resulting tables in ADLS Gen 2 managed in the Power BI service.

As stated...

Summary

In this chapter, we learned about Dataflows, what they are, and their terminology. We also learned when and how to create them, along with exporting and importing Dataflows when necessary. As stated at the beginning of this chapter, there is much more to learn about Dataflows than what we discussed in this chapter. So I suggest you read more about this fantastic piece of technology on Microsoft’s official website using the following URL: https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365?WT.mc_id=DP-MVP-5003466.

In the next chapter, we will discuss another advanced data modeling feature: composite models.

Join us on Discord!

Join The Big Data and Analytics Community on the Packt Discord Server!

Hang out with 558 other members and enjoy free voice and text chat.

https://packt.link/ips2H

The rest of the chapter is locked

You have been reading a chapter from

Expert Data Modeling with Power BI - Second Edition

Published in: Apr 2023Publisher: PacktISBN-13: 9781803246246

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

undefined

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Author (1)

Soheil Bakhshi

Soheil Bakhshi is the founder of Data Vizioner and is a sought after BI consultant. Working in data and analytics for more than 20 years, Soheil's experience lies in Microsoft BI, Data Warehousing, and Power BI platform. He possesses MSCE, MCSA certifications and is a Microsoft MVP (Most Valuable Professional). He has a passion for sharing knowledge via his website and speaking at conferences and Power BI community events locally and globally. In following his desire for simplicity and efficiency, he is behind Power BI community tools and commercial products such as Power BI Exporter and Power BI Documenter.
Read more about Soheil Bakhshi

Personalised recommendations for you

Based on your interests and search pattern

Et al.

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

BookAug 2023230 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages4

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages1

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

BookDec 2023360 pages5

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

BookAug 2023684 pages

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages5

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

BookSep 2023258 pages2

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

BookOct 2023636 pages5

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

BookAug 2023420 pages5

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

BookDec 2023240 pages

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

BookNov 2023664 pages