In this tutorial, we take you through the new Get Data option in Paginated Reports, which gives you access to the Power Query Editor and all its power transformation capabilities. Whether you're working with complex datasets or need highly formatted reports, this walkthrough will show you how to connect your data sources effortlessly and build dynamic reports with precision.
Download the files: https://prag.works/paginated-reports-in-power-bi-files
Get your certificate of completion: https://prag.works/paginated-reports-certificate
Interested in subscribing to our on-demand library of nearly 200 courses? Save 50% on an annual subscription for a limited time: https://prag.works/2024-black-friday-yt
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
00:00 - Introduction to Paginated Reports
00:28 - Understanding Power BI Reporting Tools
01:28 - Exploring Paginated Reports
02:24 - Power BI Interactive vs. Paginated Reports
03:46 - The Need for Operational Reports
05:07 - Advantages of Paginated Reports
07:02 - Connecting to Data Sources
09:35 - Using Power Query Editor in Paginated Reports
11:19 - Renaming and Formatting Data
13:16 - Merging Data Tables
16:48 - Uploading Files to OneDrive
18:32 - Navigating the Power Query Editor
19:56 - Creating a New Data Set
21:17 - Cleaning and Transforming Data
24:35 - Adding Prefixes to Columns
25:31 - Formatting and Data Types
27:20 - Merging Sales Data
29:38 - Using Advanced Editor for Code
31:08 - Grouping and Summarizing Data
33:01 - Filtering Data for Salespersons
35:17 - Expanding Merged Data
38:09 - Creating Calculated Columns
40:58 - Combining Data for Reporting
44:13 - Aggregating Sales Amounts
47:04 - Merging Quota Data
49:59 - Grouping Data for Final Report
53:17 - Adding Variance Calculations
57:38 - Parameterizing Reports
01:02:24 - Setting Up Report Parameters
01:05:07 - Creating Dynamic Data Sets
01:09:35 - Implementing Single-Value Parameters
01:14:17 - Building the Report Layout
01:18:09 - Formatting and Totals
01:22:23 - Finalizing the Report
01:25:27 - Conclusion
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks