Season 2

Namaste Power BI

Episode 28

Gateways & Data Pipelines

⏱ 45:00

Episode Summary

On-premises Data Gateway — installation, configuration, scheduled refresh, dataflows for reusable ETL, and building reliable data pipelines.

This is Episode 28 of the free Namaste Power BI course on DevWithData — covering gateways & data pipelines. Watch the video above, then pass the MCQ checkpoint to unlock the next episode and update your Data Readiness Index score.

Key Takeaways

→On-premises gateway bridges cloud Service to on-prem data sources
→Standard gateway for enterprise; Personal gateway for individual use
→Dataflows (Power Query Online) create reusable, shared ETL processes
→Scheduled refresh needs correct credentials + running gateway

⚠ Common Interview Pitfalls

•Using Personal gateway for production workloads
•Not monitoring gateway health and refresh failures
•Duplicating ETL logic in multiple .pbix files (use Dataflows instead)

Official Reference

Deepen your understanding with official Microsoft documentation.

PL-300 Official Training Course

Microsoft's official instructor-led training for the Power BI Data Analyst certification.

https://learn.microsoft.com/en-us/training/courses/pl-300t00

Power BI Documentation

Complete reference for Power BI Desktop, Power BI Service, and Power BI Embedded.

https://learn.microsoft.com/en-us/power-bi/

Content on DevWithData is original and inspired by official Microsoft resources. The links above point directly to Microsoft Learn — always the authoritative source.

← Ep 27: Data Lineage & Impact Analysis

Ep 28: Deployment Strategy (Dev → Test → Prod) →

Episode Checkpoint

Sign in to attempt the quiz and unlock the next episode.