Power Query M Primer (Part 24): Query Folding II | Ben Gribaudo

Power BI
Combining Query String Parameters—a.ka. Inclusive Record Field Combining | Ben Gribaudo
RT @ehansalytics: A little #PowerBI tip - want to get a list of columns in a table? Great for documentation! Run the following #DAX query in DAX Studio or Tabular Editor 3. Preface your tablename with '$' and ignore the RowNumber* column. Need it in #PowerQuery - use Table.Profile
A little #PowerBI tip - want to get a list of columns in a table? Great for documentation!Run the following #DAX query in DAX Studio or Tabular Editor 3. Preface your tablename with '$' and ignore …
ZERO Performance Cost Grouped Object Borders! — Havens Consulting
Video by: Reid Havens Learn how to add borders to object groups without using any additional objects or having to customize the page background ! This optimized technique insures that there is zero performance cost when loading the report page! RELATED CONTENT 🔗 Button Shadow
Power BI April 2022 Feature Summary
Welcome to the April 2022 update. We are excited to announce New format pane and Power BI Goals updates, tooltips drill actions support for more build-in visuals, error bars for clustered column and bar charts preview feature, general availability of Dynamic M query parameters. There is more to explore, please continue to read on.
Dictionary size in Tabular models reported by VertiPaq Analyzer - SQLBI
We recently discussed an issue related to the Dictionary size reported by Bravo for Power BI that, in reality, references the behavior of VertiPaq Analyzer,
Power BI Dataflows vs ADF Mapping Data Flows – Prologika
(Livestream Replay) Tabular Editor C# Scripts & Calculation Groups - with Bernat Agulló — Havens Consulting
Join Bernat Agulló and I as he shows you how to level up your skills in Tabular Editor ! He'll spend time showing you how to use C# scripts and macros to create calculation groups , diagnose and optimize your model , and much more! Plus learn how to leverage Visual Studio to cr
Flow Approval Process Under the Hood
Join Business Applications MVP Anton Robbins as he takes you through a guided journey of the things you MUST know before you Flow.

Deneb: An Alternative Approach for Custom Visual Development
In this session, Daniel will introduce you to the Vega-Lite language via Deneb - a custom visual for Power BI.
Extract data from Google Analytics with Azure Data Factory | RichardSwinbank.net

Access Google Analytics with Azure Data Factory | RichardSwinbank.net
e

Update to required permissions when using composite models on a Power BI dataset
The ability to create a composite model on top of a Power BI dataset or an Azure Analysis Services model is in preview since December 2020. Since then, we have seen great adoption of this feature and have received great feedback that allowed us to make it even better! The team has been hard at work readying the feature for general availability, and although we are not announcing that today, we have great news to share regarding permissions.
Navigating to and from a custom page in your model-driven app using client API - Power Apps
This article provides examples of navigating from a model-driven app page using the client API to a custom page.

Thin report support released
We’re excited to announce the public release of new thin report capabilities for Power BI Documenter. According to early users, these new capabilities are helping to reduce the time spen…
Data Factory V2 Activity Dependencies are a Logical AND
Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as well as their their dependency conditions. Dependency con…

Azure Data Factory – Pipeline Hierarchies (Generation Control)
Best practice for structuring your Azure Data Factory? Hello friends, this post and my next few posts have been born out of a community talk I’ve delivered a couple of times now at various co…

Handling Schema Drift in Azure Data Factory | Cathrine Wilhelmsen
A live demo failed, so here's a recorded video on how to handle schema drift in Azure Data Factory, using the Mapping Data Flows feature :)

Comparing Mapping and Wrangling Data Flows in Azure Data Factory | Cathrine Wilhelmsen
Which feature should you use to transform data in Azure Data Factory? Find your answer by comparing Mapping and Wrangling Data Flows.

Connector overview - Azure Data Factory & Azure Synapse
Learn the supported connectors in Azure Data Factory and Azure Synapse Analytics pipelines.

ADF Data Flows: Distinct Rows
Below is a method to use in ADF’s Mapping Data Flows to reduce the data stream in your data flows to only include distinct rows. This sample is available as a pipeline template here. Choose y…

Azure Data Factory Data Flow: Building Slowly Changing Dimensions
Here is a quick walk-through on how to use Azure Data Factory’s new Data Flow feature (limited preview) to build Slowly Changing Dimension (SCD) ETL patterns. The Data Flow feature in ADF is …

ADF Slowly Changing Dimension Type 2 with Mapping Data Flows (complete)
I have been putting together a series of posts and videos around building SCD Type 1 and Type 2 using Mapping Data Flows with Azure Data Factory. In this latest post, I’m going to walk throug…

What's new in Azure Data Factory - Azure Data Factory

Copy and transform data in Dynamics 365 (Microsoft Dataverse) or Dynamics CRM - Azure Data Factory & Azure Synapse
Learn how to copy and transform data in Dynamics 365 (Microsoft Dataverse) or Dynamics CRM using Azure Data Factory or Azure Synapse Analytics.

adfdataflowdocs/adf-data-flow-patterns.md at master · kromerm/adfdataflowdocs
Azure Data Factory Data Flow Documentation. Contribute to kromerm/adfdataflowdocs development by creating an account on GitHub.

Whitepapers that describe Azure Data Factory - Azure Data Factory
These whitepapers describe Azure Data Factory in depth.

Beginner's Guide to Azure Data Factory (Series) | Page 1 of 6 | Cathrine Wilhelmsen
In this Beginner's Guide to Azure Data Factory series, Cathrine covers the fundamentals in casual, bite-sized blog posts.

Azure Data Factory Activities: 5 Comprehensive Aspects
This blog discusses Azure Data Factory Activities and explains the steps required to work with them. Read along to learn more about Azure Data Pipelines.

Azure Data Factory - Key to migrate data in Azure Cloud
Learn why the Azure Data Factory is a key to migrate data across different data stores by creating pipelines and activities.
