radreza inrezarad radacad https radacad com Reza Rad

` @rad_reza /in/rezarad /radacad https: //radacad. com

Reza Rad Consultant, Trainer RADACAD Consultant, Mentor, Trainer, Speaker Blogger Microsoft Regional Director Microsoft Data Platform MVP Author of SQL Server and BI books Author of Power BI from Rookie to Rock Star book Author of Pro Power BI Architecture Power BI Trainer for thousands of Developers ` @rad_reza /in/rezarad /radacad https: //radacad. com

Single Business Analyst/Developer One Developer: Business Analyst One Reporting problem to solve: One Power BI Solution (File) Multiple Users (end users) ` @rad_reza /in/rezarad /radacad https: //radacad. com

Architecture: One Single File, Import Mode Everything in One Power BI File FAST to develop Fast to respond (because it is import mode) Agile: easy to make changes in PQ, data model, DAX and visualization Easy to maintain ` @rad_reza /in/rezarad /radacad https: //radacad. com

Analyst’s team: Multiple Developers A team of developers: Or Business Analysts One or more reporting problems to solve Multiple users ` @rad_reza /in/rezarad /radacad https: //radacad. com

Single File Challenges Multiple developers integrate dataset another application or refresh time would be slower hundreds of visualization pages model for every single change duplicates maintenance ` @rad_reza deploying the entire /in/rezarad /radacad https: //radacad. com high

Using a Query in multiple Files? ` @rad_reza /in/rezarad /radacad https: //radacad. com

Using One Power Query Table in Multiple Power BI Reports ` @rad_reza /in/rezarad /radacad https: //radacad. com

The Solution Dataflow for Transformation

What is Dataflow?

What is Dataflow? Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. ` @rad_reza /in/rezarad /radacad https: //radacad. com

Where the Output Stored? Dataflow stores the data in the Azure Data Lake storage. ` @rad_reza /in/rezarad /radacad https: //radacad. com

But I Don’t Have Azure Data Lake Subscription! Dataflow manages the Data Lake configurations internally. You won’t need anything except your Power BI accounts and subscriptions. ` @rad_reza /in/rezarad /radacad https: //radacad. com

Power BI Can Do Get Data from Dataflow ` @rad_reza /in/rezarad /radacad https: //radacad. com

Using One Power Query Table in Multiple Power BI Reports Re-usable tables or queries across multiple Power BI files, are one of the best candidates for Dataflow. ` @rad_reza /in/rezarad /radacad https: //radacad. com

FASTER refresh time ` @rad_reza /in/rezarad /radacad https: //radacad. com

Dataflow Demo

Centralized Data Warehouse Dataflow can be the ETL engine, that fuels the centralized data warehouse in Azure data lake storage. ` @rad_reza /in/rezarad /radacad https: //radacad. com

Another Problem Duplicate Dataset

The report is the visualization layer of your Power BI implementation The dataset includes the data, tables, relationships, calculations, and connection to the data source. What is the Dataset? ` @rad_reza /in/rezarad /radacad https: //radacad. com

Dataset in the Service ` @rad_reza /in/rezarad /radacad https: //radacad. com

Using a Calculation (DAX) in multiple files? ` @rad_reza /in/rezarad /radacad https: //radacad. com

The Solution Shared dataset

Shared Dataset used in multiple reports ` @rad_reza /in/rezarad /radacad https: //radacad. com

Shared Dataset Demo

The Architecture

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets ` @rad_reza /in/rezarad /radacad https: //radacad. com

Excel Users: Analyze in Excel NO Export! ` @rad_reza /in/rezarad /radacad https: //radacad. com

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets ` @rad_reza /in/rezarad /radacad https: //radacad. com

If you use other visualization tools! No Problem, we got your back. Power BI covers the limitations of Tableau ���� ` @rad_reza /in/rezarad /radacad https: //radacad. com

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets ` @rad_reza /in/rezarad /radacad https: //radacad. com

Paginated Reports Build for printing, export to PDF, paginated… ` @rad_reza /in/rezarad /radacad https: //radacad. com

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets ` @rad_reza /in/rezarad /radacad https: //radacad. com

Benefits of this architecture Decoupling Data preparation, Modelling, Visualization Faster Refresh Time for Power BI model Dataflow is not a core developer tool Multi-Developer Environment Re-use of Calculations and Modeling ` @rad_reza /in/rezarad /radacad https: //radacad. com

A tool that helps (FREE) Power BI Helper https: //powerbihelper. org ` @rad_reza /in/rezarad /radacad https: //radacad. com

Sharing via Workspaces and Apps ` @rad_reza /in/rezarad /radacad https: //radacad. com

References to Study More http: //radacad. com/online-book-power-bi-from-rookie-to-rockstar What are the Use Cases of Dataflow for You in Power BI? Getting Started With Dataflow in Power BI – Part 2 of Dataflow Series What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI Linked Entities and Computed Entities; Dataflows in Power BI Part 4 How to Use Dataflow to Make the Refresh of Power BI Solution Faster Move your Shared Tables to Dataflow; Build a Consistent Table in Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets Power BI Shared Dataset? How does it work? And why should you care? https: //radacad. com/what-is-the-xmla-endpoint-for-power-bi-and-why-should-i-care https: //radacad. com/power-bi-and-excel-more-than-just-an-integration https: //radacad. com/power-bi-helper Power BI Sharing Methods Comparison – All in one Review ` @rad_reza /in/rezarad /radacad https: //radacad. com

Please evaluate this session Your feedback is important to us! https: //aka. ms/ignite. mobileapp https: //myignite. techcommunity. microsoft. com/evaluations

Find this session in Microsoft Tech Community