HDInsight Interactive Query

Power BI is a powerful business analytics tool that is used by businesses to make data-driven decisions. With its ability to connect to different data sources, it has become an indispensable tool for many businesses. One of the data sources that Power BI can connect to is the HDInsight Interactive Query data source. The HDInsight Interactive Query data source is a big data solution that allows for the processing of large data sets. In this article, we will discuss the Power Query M language code for connecting to the HDInsight Interactive Query data source from inside Power BI.

What is Power Query?

HDInsight Interactive Query

Power Query is a data transformation and data preparation tool that is part of the Power BI suite. It allows users to extract, transform, and load data from different sources. With Power Query, you can connect to different data sources, perform transformations on the data, and load the transformed data into Power BI.

What is HDInsight Interactive Query?

HDInsight Interactive Query is a big data solution that allows for the processing of large data sets. It uses Apache Hive as a query engine and is designed to run interactive Hive queries on data stored in Hadoop. HDInsight Interactive Query provides fast query performance and is ideal for data analysts who need to query large datasets.

Connecting to the HDInsight Interactive Query Data Source from Inside Power BI

To connect to the HDInsight Interactive Query data source from inside Power BI, you need to use the Power Query M language. The Power Query M language is a functional language that is used to perform data transformations in Power Query. Here’s how to connect to the HDInsight Interactive Query data source from inside Power BI:

1. Open Power BI and click on the “Get Data” button on the Home tab.

2. In the “Get Data” window, select “HDInsight Interactive Query” and click “Connect”.

3. In the “HDInsight Interactive Query” dialog box, enter the required details such as the cluster name, username, password, and database name.

4. Click “OK” to connect to the HDInsight Interactive Query data source.

Here’s an example of Power Query M language code for connecting to the HDInsight Interactive Query data source from inside Power BI:


let

Source = HDInsight.InteractiveQuery(“https://.azurehdinsight.net/;Username=;Password=“, [Query=”SELECT FROM .“]),

#”Expanded Value” = Table.ExpandRecordColumn(Source, “Value”, {“column1”, “column2”, “column3”}, {“column1”, “column2”, “column3”})

in

#”Expanded Value”


Conclusion

In this article, we discussed the Power Query M language code for connecting to the HDInsight Interactive Query data source from inside Power BI. We also discussed what Power Query and HDInsight Interactive Query are and how they are used. With this knowledge, you should be able to connect to the HDInsight Interactive Query data source from inside Power BI and start analyzing your big data.

Power BI Training Courses by G Com Solutions (0800 998 9248)

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)

    Similar Posts