Fabric and Azure

Build a Fabric pipeline that loads a file daily, feeds a Direct Lake report with no refresh step, and shows every failed run. Tested on a trial.

When to use Dataflows Gen2 and when to use Spark notebooks in Microsoft Fabric, with a decision table, a PySpark merge example and the common pitfalls.

How Power BI fits inside Microsoft Fabric: what changed since Fabric launched, how a report connects to Fabric data, and what Direct Lake mode does differently.

A cloud migration strategy for a BI or data warehouse estate: the rehost, replatform or refactor decision, a phase-by-phase checklist and a Fabric example.

Use a dataflow when several Power BI models need the same cleaned tables. How Gen1 and Gen2 differ, what each needs to run, and how to build one.

Connect Power BI to Snowflake in five steps: pick the connector, enter the warehouse, sign in, choose tables, then Import or DirectQuery.

TO_JSON_STRING converts a BigQuery value to a JSON string. Syntax, pretty_print, row comparison, TO_JSON vs TO_JSON_STRING, and PARSE_JSON.

What a data lake is, how it differs from a warehouse and a lakehouse, and how it works on Microsoft's stack: OneLake, ADLS Gen2, Delta tables and Direct Lake.

Azure Data Factory and Data Factory in Fabric compared: datasets versus connections, billing model, and which one fits a Fabric-based team.