Power BI Tips and Tricks - Vol. 3

Interactive guide mainly focused on how to develop a Power BI enterprise scalable solution, leveraging Dataflows, Datamarts, Deployment pipeline and Power Query online. The guide also includes specific Power Query Tricks aimed to simplify things when dealing with Dataflows.

The list of topics includes:

The core focus: Build Scalable Solutions

1. The overall environment: what is a scalable solution, what items/concepts are required to build one and the whole picture of a fully implamented enterprise solution.
2. Create a Data Pipeline: part one of building a scalable solution, starting from building the data infrastructure.
3. Create a Reporting Pipeline: part two of building a scalable solution, using the data infrastruture for reporting.

Power Query Tricks

This sections offers some ad-hoc tricks to overcome some challenges that can be encountered when dealing with Power Query (particularly using Dataflows). Here I also provide M-Codes that can be directly copied and pasted if a similar challenge is encountered.

1. Using List functions for creating lookup tables.
2. Implementing a dynamic element in the data source string in Power Query.
3. Indicator-based deduplication, for prioritising data sources, when multiple tables need to be appended.
4. Management of the provisional tables, within a transofrmation Dataflow.