Power BI Tutorial: 4 Ways To Get Data

Published: 10 July 2018
on channel: Guy in a Cube

67,162

783

In this Power BI tutorial, Adam looks at 4 ways to get data in Power BI. This focuses on Power BI Desktop and the main storage modes - Import, DirectQuery and Live Connections to Analysis Services. If you are new to Power BI, be sure to check out this Power BI Tutorial: 4 ways to get data.

Import (Excel) [01:46:21]

Import (SQL) [04:28:17]

DirectQuery (SQL) [06:48:07]

Live Connection (Analysis Services Tabular) [10:10:08]

Service/Push/Streaming [12:13:20]

DirectQuery Documentation:
- Whitepaper: https://blogs.msdn.microsoft.com/anal...
- Data Sources: https://docs.microsoft.com/power-bi/d...
- Limitations: https://docs.microsoft.com/power-bi/d...
- Kasper de Jonge's Blog regarding Performance: https://www.kasperonbi.com/to-directq...

LET'S CONNECT!

Guy in a Cube
-- https://guyinacube.com
--   / guyinacube
--   / guyinacube
-- Snapchat - guyinacube
--   / guyinacube

**Gear**
Check out my Tools page - https://guyinacube.com/tools/ #powerbi #guyinacube