PowerBI - Import Data from Locale
3rd Lesson
In this lesson we will see how to import the following files from your local computer or from a network share, CSV, Excel, MSAccess and SQL Server.
On the part of SQL Server we will also do a little insight into DirectQuery and the creation of ODBC drivers
=========== S O S T I E N I M I ==================
Subscribe to this channel to access the benefits: / @lodovicodincau
Buy a product: https://lodovicodincau.myspreadshop.it/
Donate: https://www.paypal.com/donate/?cmd=_d...
======= SAFE AND AFFORDABLE SOFTWARE! ==
Office, Windows, Antivirus, VPN, Server: https://mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mouse: https://amzn.to/3s1XwF2
Yeti microphone: https://amzn.to/3MDCggU
Microphone without stand: https://amzn.to/3LAoWcS
Yeti filter: https://amzn.to/3KwKAO2
Sony Alpha 6400L: https://amzn.to/3t5cN8u
Elgato Stream Deck: https://amzn.to/3NDf0RM
Elgato Cam Link 4K: https://amzn.to/3NHXtIb
Elgato Facecam: https://amzn.to/3F1Cagk
TC Helicon Mixer: https://amzn.to/3TbTmoZ
RGB keyboard: https://amzn.to/3MGytiL
2k Gaming monitors: https://amzn.to/3vYb7OP
Switch: https://amzn.to/372aYl8
Microsoft 365 Family: https://amzn.to/38H85qc
Microsoft 365 Business: https://amzn.to/3OSDQO2
My name is Excel - troubleshooting: https://amzn.to/3vVBPb1
The Definitive Guide to DAX: https://amzn.to/376c7s2
Prime Student 90 days free: https://amzn.to/3MJ8LKw
============ R I S O R S E ====================
DOWNLOAD for "Student Plus" or higher: https://drive.google.com/file/d/19eIv...
Channel index - Available to subscribers only: https://docs.google.com/spreadsheets/...
Lesson Chapters:
1. Introduction 0:00
2. How to import data 1:38
3. The files we're going to import 3:05
4. We import from CSV file 3:52
5. Queries, Applied Steps, and Powerquery Language 5:33
6. We import from Excel file 9:43
7. We import from MS Access 12:00
8. SQL Server Introductory Notes 1:07 PM
9. We import from SQL Server with Native driver 14:38
10. We import from SQL Server with ODBC driver 18:53
11. How to Create ODBC Driver 19:30
12. We finish the import with the 22:40 ODBC driver
13. We load the data into PBI Desktop 23:13
14. Greetings 11:53pm
#PowerBI #PowerQuery #ImportData #CSV #Excel #MSAccess #SQLServer