What Are Power BI Data Connectors and Why They Matter
After watching this video, you'll understand what Power BI data connectors are and how to find and use them effectively to connect to your data sources.
Adam Saxton explains the concept of data connectors in Power BI and Excel, demonstrating how connectors enable communication between Power BI and various data sources like Excel files, SQL Server, and more. He shows how to find available connectors within Power BI Desktop and Excel's Power Query, discusses connection types such as Import and DirectQuery, and highlights the importance of understanding where connections originate. Adam also covers scenarios when a connector isn't available, introducing ODBC connectors and custom connectors like those from CData, and explains considerations for drivers and gateway configurations.
✅ KEY TAKEAWAYS
Understand what Power BI data connectors are and their role in connecting to data sources.
Learn how to find and use connectors within Power BI Desktop and Excel Power Query.
Recognize the difference between connection types like Import and DirectQuery.
Discover options when a native connector is unavailable, including ODBC and custom connectors.
Be aware of driver installation and gateway considerations for successful connections.
🎥 RELATED VIDEOS
More from Guy in a Cube: / @guyinacube
⏱️ CHAPTERS
00:00 Introduction to Connectors
00:28 What is a Connector?
00:59 Demonstration: Finding Connectors in Power BI
01:52 Connectors in Excel and Power Query
02:15 Connection Origin and Network Implications
02:50 Connection Types: Import vs DirectQuery
03:16 Checking Connector Availability
04:38 Using ODBC When No Connector Exists
06:01 Driver Installation and Bitness Considerations
06:23 Custom Connectors and CData Example
07:17 Gateway and Driver Setup for Published Reports
08:07 Summary and Final Thoughts
Yooo! 🙌 take your data skills to the next level and join fellow data professionals in our community THE CUBE: https://guyinacube.com
🌐 LET'S CONNECT!
Official website: https://guyinacube.com
LinkedIn: / guyinacube
Facebook: / guyinacube
Instagram: / guyinacube
Bluesky: https://bsky.app/profile/guyinacube.com
X: https://x.com/guyinacube
🎤 HOST
Adam Saxton
#guyinacube #powerbi #microsoftfabric #powerquery #dataconnectors