Edit

Hadoop File (HDFS)

  • Article

Summary

Item Description
Release State General Availability
Products Excel
Power BI (Semantic models)
Authentication Types Supported Anonymous
Windows
Microsoft account
Function Reference Documentation Hdfs.Contents
Hdfs.Files

Note

The Power Query Hadoop File (HDFS) connector doesn't support scheduled refresh of on-premises data sources in Power BI semantic models or Excel.

Capabilities Supported

  • Import

Connect to Hadoop Files (HDFS) from Power Query Desktop

Power Query desktop includes Excel and Power BI as experiences.

To make the connection to Hadoop File (HDFS), follow these steps:

  1. From Get Data, select the Other category, select Hadoop File (HDFS), and then select Connect. More information: where to get data

    Screenshot of the Get Data dialog, showing the Hadoop File (HDFS) database selection.

  2. In the window that appears, enter the server name of your Hadoop File (HDFS) instance.

    Screenshot of the Hadoop File (HDFS) dialog, showing the name of the server added.

  3. Select OK.

  4. You can either select anonymous access, windows access, or Microsoft account, select the level to apply the settings to, and connect. For more information, see: Authentication with a data source.

    Screenshot of the Hadoop File (HDFS) anonymous access dialog.

  5. Select either Load to load the table, or Transform Data to open the Power Query Editor where you can filter and refine the set of data you want to use, and then load that refined set of data.