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.
Connecting 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.
Connecting 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.
Analyzing 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.
Last updated