Daniel Scott

Introduction In this blog post I will share how to effectively leverage conditional formatting with a low code approach suitable for enterprise grade solutions. I have found that there are two key components that are critical for success: Field Values – predefined measures that dynamically specify colour values, icons and even Unicode characters. Power BI dataflows – a low code method that creates a single source of truth of field values and is effortless to manage and ensure consistency...

In this blog post I will share with you how to effectively leverage the Dataflow Gen2 Fast Copy capability when ingesting large volumes of data. I have found that there are two key components that are critical for success: Enable high scale compute – allows use of Fast Copy connectors that benefit from the scalable backend of the pipeline Copy Activity. Meet prerequisite criteria – Fast Copy is only supported for a limited number of Dataflow Gen2 connectors and a limited number of...

This blog post demonstrates how to effectively use incremental refresh with binary files to drastically improve the refresh performance of your Power BI datasets and dataflows. Incremental refresh is widely understood and employed for structured, relational data sources like SQL Database and Azure Synapse. It is not as commonly known that incremental refresh can also be harnessed for other data sources such as binary files. The key to success is to ensure the binary files are saved in a...