Power BI · Chapter 52
Power BI Desktop: Get Data — Every Source and Connection Type
Every Get Data door in one map: files, MySQL, IBM Db2, Azure, REST, ODBC — with auth, mode, M sketches, drivers and gateway rules.
Fictional sample data for learning. Brands belong to their owners. Numbers are made up for class.
In this chapter
- Open Get Data and find File, Database, Azure, Online services and Other connectors.
- Connect Excel, CSV, JSON, PDF, Folder and SharePoint folder with Import.
- Connect SQL Server, MySQL (Connector/NET), PostgreSQL (Npgsql), Oracle and IBM Db2 (Data Server driver).
- Choose Import vs DirectQuery vs Live vs Dual and the right authentication type.
- Call a Web / OData / REST source with headers or an API key safely.
- Explain privacy levels, native SQL, query folding, parameters and when a gateway is required (Ch 39).