PowerBI - Importare Dati da 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