Dynamics 365 Marketing analytical reporting with Power BI
Power BI
Calculated columns and measures
VertiPaq – “Brain & Muscles” behind Power BI - Data Mozart
Inside VertiPaq – Compress for success - Data Mozart
Chris Webb's BI Blog: Understanding Power Query Query Diagnostics Data With The Diagnostics.ActivityID M Function
On comparing Power BI with other tools - SQLBI
Power BI is a model-based tool - SQLBI
Power BI usage scenarios: Prototyping and sharing - Power BI
Power BI usage scenarios: Advanced data model management - Power BI
Power BI usage scenarios: Advanced data preparation - Power BI
he use of separate dataflows based on purpose: staging, transformation, or final. We recommend using composable building blocks to obtain greater reuse, in various combinations, to support specific user requirements. Composable building blocks are described later in this article.
focus of this advanced data preparation scenario is on:
For a dataflow that's intended for reuse, it's common (but not required) that the creator belongs to a centralized team that supports users across organizational boundaries (such as IT, enterprise BI, or the Center of Excellence).
A staging dataflow is created in a workspace that's dedicated to the centralized management of dataflows. A staging dataflow copies the raw data as-is from the source. Few, if any, transformations are applied.
Use of composable building blocks is a design principle that allows you to manage, deploy, and secure system components, and then use them in various combinations. Creating modular, self-contained dataflows that are specific to a purpose is a best practice. They help to achieve data reuse and enterprise scale. Modular dataflows are also easier to manage and test.
Side effects of rounding differences in Power BI - SQLBI
The Three Mental Models Model for Data Visualization
Microsoft Power Platform 2022 release wave 1 plan overview - Power Platform Release Plan
describes new features releasing from April 2022 through Se
Release planner (BETA)
Useful script snippets | Tabular Editor Documentation
i
Power BI + Adobe = Magic - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Comparative Analysis by different values in same dimension in Power BI
RLS with Calculation Groups, Hierarchy, & Drill Throughs — Power Bi, Dax
Demystifying Custom Partitions in Power BI - Guy in a Cube
reporTee
On-premises data gateway April 2022 update is now available
Codagence - Better version of PowerBI embedded dashboard | Product Hunt
How PowerBI Composite Model Works
Working with Lists in Power Query - Let's Count Words - P3 Adaptive
Poor Man’s Paginated Reports in Power BI
Solving the Query - Pivot Edition - P3 Adaptive
Use Paginated Reports to Create a Gantt Chart
Download Power BI Reports using PowerShell | Purple Frog Systems
Chris Webb's BI Blog: Filtering An Excel Cube Function Report By A List Of Manually-Entered Values
Creating Ordinal Numbers (1st, 2nd, 3rd) in Power BI - Gorilla BI
DAX
BI Framework
Data Visualization
PowerApps