Season 1

Namaste Power BI

Episode 3

Data Import & Sources

⏱ 40:00

Episode Summary

Connecting Power BI to real-world data sources — Excel, CSV, SQL Server, web APIs, SharePoint. Credential management, data preview, and choosing the right connector.

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

Key Takeaways

→Get Data is the universal entry point for all connections
→Credentials are stored per-source and persist across refreshes
→Navigator window lets you preview and select tables before loading
→Parameter queries enable dynamic source switching

⚠ Common Interview Pitfalls

•Loading all columns when only a few are needed
•Using web connectors for frequently changing APIs without error handling
•Forgetting to store credentials securely for scheduled refresh

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 2: Architecture Deep Dive

Ep 4: Import vs DirectQuery →

Episode Checkpoint

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