Skip to main content
Skip table of contents

Exporter to Microsoft Power BI

This documentation references external sources. Nexthink does not have control over the accuracy of third-party documentation, nor any external updates or changes that might create inconsistencies with the information presented on this page. Please report any errors or inconsistencies to Nexthink Support.

This document describes how to export Nexthink data into Azure Data Lake Gen2 in CSV format to be used in Microsoft Power BI.

Prerequisites

  • An Azure subscription.

  • A storage account that has a hierarchical namespace. This article assumes that you've already created a storage account.

  • One of the following roles for the storage account: Blob Data Reader, Blob Data Contributor or Blob Data Owner.

  • One or multiple Nexthink Data Exporters configured in the Nexthink web interface that are exporting files into the Azure Data Lake Gen2 mercuryteam container.

  • One or multiple CSV files containing Nexthink data that is located in your storage account.

  • A Power BI Desktop instance.

Connect to Azure Data Lake Storage Gen2 from Power Query Desktop

Follow the steps listed in the Microsoft Documentation.

If you happen to choose CDM (Common Data Model) view instead of File System view, the following option appears:

In the fourth step of the Microsoft Documentation, the Navigator dialog box shows all files under the URL you provided. Verify the information, then select Transform Data to transform the data in Power Query or Load to load the data.

Connect to Azure Data Lake Storage Gen2 from Power Query Online

Follow the steps listed in the Microsoft Documentation.

Limitations

Refer to the Microsoft Documentation to learn more about the limitations of connecting Power BI Desktop to an Azure Data Lake Storage Gen2.

Analyze data in Azure Data Lake Storage Gen2 with Microsoft Power BI

We strongly recommend you leverage the online Microsoft documentation to analyze and visualize data stored in a storage account that has a hierarchical namespace (Azure Data Lake Storage Gen2) using Power BI Desktop.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.