How to create connection only in Power Query

Описание

In this video I will show How you can create connection only in Power Query. It is very helpful when you don't want to load the data or the add the data into Data Model for analysis in the Pover Pivot.

Other videos related to Power Query.

1 How to get Started with Power Query http://www.youtube.com/watch?v=JShNMwUgByY
2 How does ETL works in Excel Power Query http://www.youtube.com/watch?v=KpFxh4fFZOM
3 How to Import Data from Current WorkBook in Power Query Excel http://www.youtube.com/watch?v=wfHdbTnbxXI
4 How to Import Text File Data into Excel Using Power Query http://www.youtube.com/watch?v=YA9fpNksEFg
5 How to Import CSV File Data into Excel Using Power Query http://www.youtube.com/watch?v=4CTFddcrLfQ
6 How to Import Google Sheet Data in Excel http://www.youtube.com/watch?v=Agn4knvHwYY
7 How to combine multiple sheets in Excel using Power Query http://www.youtube.com/watch?v=rOq0cKrpWig
8 How to Import PDF Data into Excel Using Power Query http://www.youtube.com/watch?v=TAOd1jx8VJk
9 How to Manage Columns in Power Query http://www.youtube.com/watch?v=GC04wi22ScI
10 How to use First Row As Header Power Query http://www.youtube.com/watch?v=HmTeCqxFdHw
11 How to use Fill Up Fill Down in Power Query https://youtu.be/kGjwChe7b00
12 How to UnPivot Columns _ Combine multiple columns _ Power Query https://youtu.be/Qm08489ZTsI
13 How to Sort Multiple Column in Power Query https://youtu.be/6wDhq5nnUAM
14 How to Split Columns in Power Query https://youtu.be/SaM2iekMUzE
15 How to use Group By in Power Query https://youtu.be/kgv65BGdBsg
16 How to Filter Data in Power Query https://youtu.be/wCpco2Igfz8
17 How to Merge Columns in Power Query https://youtu.be/IVUlyiQXJpg
18 How to Add Index Number in Power Query https://youtu.be/VdTMs_MS4BY
19 How to change Date format in Power Query from CSV File https://youtu.be/NGWg6XOoERo
20 How to create Duplicate Columns & Move Columns in Power Query https://youtu.be/KrxiYZRHKPg
21 How to Identify Errors in Power Query https://youtu.be/wV47dM9TD48
22 How to use Left Function in Power Query https://youtu.be/DuuL_htwy04
23 How to use Right Function in Power Query https://youtu.be/fpQOtb0Egvs
24 How to use Extract text and Transform Column in Power Query https://youtu.be/VlD7kdL7WMw
25 How to use Lower Upper Case Power Query https://youtu.be/6Evqr2S36cQ
26 How to Add Prefix Suffix in Power Query https://youtu.be/ct0mHeA6AMQ
27 How to work with Dates in Power Query https://youtu.be/1JK0Y5Eb5A8
28 How to check Distinct and Unique Values in Power Query https://youtu.be/34Gux3thvh0
29 How to Split Column Data into Rows in Power Query https://youtu.be/Lz63u87t0H8
30 How to get files names from Folder https://youtu.be/_xzp3jsSV3Y
31 How to name the Queries in Power Query https://youtu.be/PZZA8wqnZRo