Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.
In the POWER QUERY ribbon tab, select From Other Sources > From Hadoop File (HDFS).
In the Hadoop Distributed File System dialog box, enter a Server Name.