Create your first Dataflow in Power BI

Welcome to Power BI Dataflows Step by step tutorial series for beginners and advanced level users. Throughout this entries session series, we will learn about Power BI Dataflows. This is a complete full beginner course for the beginners and intermediate Power BI user who wants to learn about Power BI Dataflows. You are watching the second episode of this series and during this session, we will learn how we can create our first Power BI Dataflow. First, we will try to understand the overall architecture of our database, and then we will create our first Premium Per User Workspace to create a data flow within it! In Power BI there are four different ways to create our Power BI Dataflow!

During this entire step-by-step series, first, create PPU Workspace and then download and install data gateway. Once we install our data gateway, we will create our first data flow. We will load the tables from our On-Premise SQL Server database. Once we load the data we will perform ETL operation in PowerQuery Online. Once the dataflow is saved, we will refresh our data and configure the schedule refresh as well.

Stay tuned throughout the entire session for more information.

We will cover the following points in this video:
1. Different ways to create Power BI Dataflows
2. A Quick look at Power BI Dataflow
3. Quick Guide to create dataflow in Power BI
4. Add Datasource and Table to Power BI Dataflow
5. Create Dataflow in Power BI
6. Configure Refresh in Power BI Dataflow
7. Create your first Power BI Dataflow
8. Get Started with Power BI dataflow

Chapters:
00:00 Start
00:29 Follow on Instagram
01:55 Create Premium Per User Workspace
03:20 Create Power BI Dataflow
03:31 Quick Guide to create new dataflow in Power BI
04:56 Overview of Datasource and Table
07:18 Create the first Dataflow to add Category Table
08:14 Download Data Gateway
09:38 Register Data Gateway
10:08 Gateway Installation Links
10:41 Manage Data Gateway in Power BI Service
12:13 Create Dataflow in Power BI
13:11 Load Table
14:30 PowerQuery Online
14:53 Different Indicator
15:33 Perform ETL Operations
16:17 Provide Dataflow Name
16:36 Important!!! Refresh Data
17:16 Configure Schedule Refresh
18:23 Next Session
19:05 Subscribe!!

#PowerBI #Dataflows #PowerBIBeginner #PowerPlatform #Microsoft #DigitalDhruvin #DhruvinShah #PowerAddicts #Analytics #DataAnalytics #ETL

Blog Reference Link for different icons in Power Query Online!!

Please refer to other Episodes from this series!

Full Playlist Link for Power BI Dataflows step by step series:

Full Playlist Link for Power BI Dataflows step by step series:

Chapter 0: Power BI Dataflows [Full Course Outline]

Chapter 1: What is Power BI Dataflows?

Chapter 2: Create your first Power BI Dataflow

Chapter 3: Linked Tables and Compound Tables in Power BI Dataflows

Chapter 4:
Create back up for Power BI Dataflows (Import Model in Dataflow)

Chapter 5:
Power BI Dataflows - Feature Comparison - Pro Vs Premium

Chapter 6:
How to consume Power BI Dataflows in Power BI Report?

Chapter 7
Connect Power BI Dataflow as DirectQuery Mode in Power BI

********************

📷 Follow me on Instagram:

🌐 Looking for Consultancy? Connect Here!

🌐 Follow me on all social Media Handles:

[Wanderingduowithajay]

Hi Dhruvin, if a sales team added changes in a dataset, how do i determine the dataflow from Db to dashboard? Also if those changes directly affect my reports how do we tackle that issue?

[krishnakishorepeddisetti]

Hi druvin... One question... Incase.. If I add multiple tables in a single data flow.. And in future.. If I want to make changes for multiple tables.... Can i do that??

Help me with your inputs.. Thank you

[RithDil]

Thank you so much Dhruvin! This video helps me to understand Dataflow clearly.

[shwetkumar]

Hi sir can we only share datasets with the end users in power Bi only datasets?

[chalanatyjostna]

How to practice this? because i dont have PPU license

[saikatchakraborty]

Different from Other Training... I love this... Thanks Dhruvin. Please create videos on RLS

[shaliniakepati]

Hi, In part 1, you told that we can create dataflows with pro user but in this video you asked to establish the ppu connection, why so..what is the advantage of enabling ppu user to create dataflows, hoping the ans soon.

Thank you in advance

[jonathanfernandezferrer]

Hi Dhruvin, sorry i have A question from the company I work for. We are trying to create a dataflow in a workspace by connecting to a table of a dataflow in another workspace. We can connect to the table, but the new dataflow can only replicate that table, we cannot save the new dataflow after applying a simple filter of the table of the original dataflow. The new dataflow cannot be saved after applying a simple transformation to the original table (message from power BI referencing “Linked tables”).thank you

[salvikasingh]

Thank you so much 🤩 very helpful video.

[riteshkumar-vnfv]

Can I create a new dataflow using just a pro license?

[vishalbhakoria]

What's purpose of creating Dataflow?

[santoshhmt]

Meaure table
Measure Min Age Max Age
M1 0 18
M2 20 65
M3 65 100
M4 40 75

i have 2 slicers measure and age category
if i select M1 respected age category must visible in age category slicer

age category make use of min age and max age column
if i select M1 from measure slicer i need values in age category like below
0-10
11-18
if i select measure 2 from measure slicer i need values in age category slicer like below
20-30
31-40
41-50
51-60
61-65

if i select M3 from measure slicer i need values in age category slicer like below
65-74
75-84
85-94
94-100

age category start from min age and end with max age, interval of 10
power bi

[childvideos]

Sir Please explain why do we use datafolw.

[hariniloganathan]

Your content is really good. But you are wasting so much time just by asking us to follow you in social networks.