How to Automatically Update Partitions in Power BI Semantic Models

omnidata automatically updating partitions in power bi

Often when working with large semantic models, we see fact tables with many partitions.  A common pattern is to partition by a date grouping (ie month, quarter, etc).  Partitioning a fact table this way can provide many benefits: greater control over refreshes, faster refresh times, ability to re-run specific partitions if needed. This approach also…

Read More

Power BI Dataset Refresh Part 2 – Confirming a Dataset Refresh

OmniData™ Power BI Dataset Refresh Part 2 Tech Talk Thursday

Welcome to Part Two of this two-part video series on dataset refresh from Power BI within our Synapse Analytics pipeline using Power BI REST API presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In this second video of our two-part series, we will be exploring how to check the status of whether or not a…

Read More

Build a Synapse Pipeline Part 2: Expanding on Control Tables

Tech Talk Thursday: Build a Synapse Pipeline Part 2: Expanding on Control Tables

Welcome to Part Two of this three-part video series on creating a pipeline to handle both full and incremental refreshes in Azure Synapse presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In Part One, we created our control table using Delta Lake. If you missed Part One, please check out that video because it is…

Read More

Explore the “If” Condition Within Azure Synapse Pipelines

OmniData™ Tech Talk Thursday If Conditions in Azure Synapse Pipelines

Don’t miss this tutorial for beginners just learning about Azure Synapse Pipeline configurations and analytics. This tutorial builds on the concept of using Switch statements to do conditional evaluations in Synapse Pipelines. You can check out that short video in a previous Tech Talk Thursday. In this video, Ray Marquina, our Principal Solutions Architect, will…

Read More