Power BI Dataflows Dennes Torres Going Beyond the

Power BI Dataflows Dennes Torres Going Beyond the Self-Service

Own your career with interactive learning built by community and guided by data experts. Get involved. Get ahead. Explore your PASS community #sqlsat 900 Free online webinar events Local user groups around the world Connect with the global data community . org Online special interest user groups Learning on-demand delivered to you Get involved

Missed PASS Summit 2019? Get the Recordings Download all PASS Summit sessions on Data Management, Analytics, or Architecture for only $399 USD More options available at PASSstuff. com #sqlsat 900

We are thrilled to say the first ever PASS Virtual Summit will be taking place this November! We will be launching PASS Summit into a whole new world, and with that comes exciting opportunities with what we can offer you. We will go beyond simply moving sessions online to fully embracing everything a virtual environment can offer. Find out more at PASS. org/summit #sqlsat 900

Thank you to our Global Sponsors and Supporters

This event was sponsored by Microsoft Learn more about SQL Server 2019 today: -Get free training: aka. ms/sqlworkshops -Download the SQL 19 e. Book: aka. ms/sql 19_ebook #sqlsat 900

Agenda The Data Warehouse Ecosystem Self-Service in Power BI Dataflow First Concepts On-Premises Data Gateway How Dataflow Works Refresh Schedule Using CDM Folders #sqlsat 900

The Data Warehouse Ecosystem

The Data Warehouse Ecosystem Self-Service BI OLTP systems Data Warehouse Data Preparation / ETL #sqlsat 900 Reports and dashboards Data Lake OLAP / Analytics Models

E n t e r p r i s Enterprise IT e Main Office #sqlsat 900 Sardegna Malta Europe Departamental IT EUA North America Asia Mexico Russia China

Self-Service in Power BI

Self-Service in Power BI #sqlsat 900

PBIX Files Power Query ETL #sqlsat 900 Tabular Model

#sqlsat 900

PBIX Files Da ta flo w Power Query ETL #sqlsat 900 Tabular Model Da t as et

Data Flow: The Solution #sqlsat 900

How Dataflow Works

#sqlsat 900

How Dataflow Works Only Available in App Workspaces Requires a gateway for most data sources Each dataflow can access a single gateway Some combination features are Premium only #sqlsat 900

#sqlsat 900

On-Premises Data Gateway

On-Premises Data Gateway #sqlsat 900

Gateway Installed as a Service #sqlsat 900

Gateway Management from the Portal #sqlsat 900

Refresh Schedule

#sqlsat 900

Demo

Using CDM Folders

Common Data Model A set of standard data models A standard format for data folders A method for sharing data across different services #sqlsat 900

Deliver ready-made insights to Power BI users from Azure IT professionals, Data scientists Business analysts No code, low code Ingest #sqlsat 900 Low to high code Visualize and report Model & serve Train & predict Advance data prep Orchestrate & move Power BI Azure SQL Data Warehouse Azure Machine Learning Azure Databricks Azure Data Factory Ingest Power BI dataflows CDM folders Azure Data Lake Storage

Two working modes Power BI Pro • Reading Folders created by other services #sqlsat 900 Power BI Premium • Writing folders for other services

#sqlsat 900

Premium Only Features • • • Explicit ADLSg 2 storage Linked Entities Incremental Refresh #sqlsat 900

References • • https: //ssbipolar. com/2019/05/06/session-resourcespower-bi-dataflows-and-azure-data-lake-integration/ https: //www. sqlchick. com/entries/2019/3/28/three-ways -to-use-power-bi-dataflows https: //docs. microsoft. com/en-us/power-bi/servicedataflows-connect-azure-data-lake-storage-gen 2 https: //ssbipolar. com/2018/11/27/power-bi-dataflowsfaq/ #sqlsat 900

Speaker Bio Senior Software Developer Ascent Software Trainer MCT, MCSE Data Platform, MCSE BI, MCSD Web Development Malta Data Platform UG Leader Dennes. Torres Malta @Dennes MMDPUG http: //Malta. Pass. Org https: //br. linkedin. com/in/dennestorres dennes@bufaloinfo. com. br http: //youtube. com/c/dennestorres #sqlsat 900

Thank You to our Global SQLSaturday Sponsors #sqlsat 900

Thank you