When working with Power BI, connecting to data sources is a critical step. One data source that is becoming increasingly popular is Hive LLAP. Hive LLAP is a data warehouse technology that allows for querying of large datasets stored in the Hadoop Distributed File System (HDFS). In this article, we will explore how to connect to the Hive LLAP data source using Power Query M Language code from inside Power BI.
Prerequisites
Before we begin, there are a few prerequisites that need to be in place:
– Power BI Desktop must be installed on your machine.
– The Hive LLAP data source must be accessible from your machine.
– The required ODBC driver for Hive LLAP must be installed on your machine.
If any of these prerequisites are not met, please ensure they are in place before proceeding.
Creating the Connection
To create a connection to the Hive LLAP data source, we will first need to open Power BI Desktop. From the Home screen, select the “Get Data” option in the ribbon. In the “Get Data” window, select “ODBC” from the list of available connections.
In the “ODBC” window, select the “Advanced” option. In the “Advanced Options” window, we will need to enter the connection string for the Hive LLAP data source. The connection string will look something like this:
Driver={ODBC Driver for Apache Hive};Host=;Port=;Schema=;UID=;PWD=;
Replace `` with the hostname or IP address of your Hive LLAP server, `` with the port number for the Hive LLAP server (default is usually 10000), `` with the Hive database name, `` with the username for connecting to the Hive LLAP data source, and `` with the corresponding password.
Once the connection string has been entered, select “Connect” to create the connection to the Hive LLAP data source.
Querying the Data
Now that we have created the connection to the Hive LLAP data source, we can begin querying the data. To do this, we will need to add a new query to our Power BI report. From the Home screen, select the “New Source” option in the ribbon. In the “New Source” window, select “Blank Query”.
In the “New Query” window, select the “Advanced Editor” option. In the “Advanced Editor” window, we can begin writing our Power Query M Language code to query the data. Here is an example of Power Query M Language code for connecting to the Hive LLAP data source:
let
Source = Odbc.DataSource(“dsn=“),
Query = “SELECT FROM
“,
Results = Odbc.Query(Source, Query)
in
Results
Replace `` with the name of the ODBC data source name configured on your machine and `
` with the name of the table you wish to query.
Once the Power Query M Language code has been entered, select “Done” to create the query. From here, you can manipulate the data as needed using Power Query transformations.
Conclusion
Connecting to the Hive LLAP data source from inside Power BI is a powerful capability that allows for querying of large datasets stored in the Hadoop Distributed File System. With the Power Query M Language code provided in this article, you can easily create a connection to the Hive LLAP data source and begin querying the data.
Power BI Training Courses by G Com Solutions (0800 998 9248)
In today’s data-driven world, cleaning and preparing data for analysis is a crucial step. Messy or inconsistent data can lead to inaccurate insights and hinder decision-making. Thankfully, tools like Power Query in Microsoft Excel provide powerful capabilities to streamline the data cleaning process. One such feature, the Replace Values command, empowers users to efficiently replace specific values within their data. In this article, we will explore the benefits and practical applications of the Replace Values command, helping you supercharge your data cleaning efficiency.
In the New Power BI Online Training Course: Power Query Essentials, you will learn the basics of Power Query; a robust data connection and transformation tool which is built into Power BI and which allows you to connect to data from a wide variety of sources and then transform that data into exactly the right…
In today’s data-driven business landscape, organizations rely on comprehensive and visually appealing data dashboards to gain actionable insights and make informed decisions. These dashboards provide a bird’s-eye view of key performance indicators (KPIs) and enable stakeholders to monitor business performance, identify trends, and uncover opportunities. One powerful tool for creating compelling data visualizations is Microsoft Power BI, a leading business intelligence platform.
Power BI, a powerful business intelligence tool developed by Microsoft, has gained significant popularity in the world of data analytics and reporting. It enables users to transform raw data into visually appealing and interactive dashboards. Dashboards play a crucial role in presenting insights and facilitating data-driven decision-making. In this article, we will explore the concept of Power BI object references and how they can supercharge your dashboard creation process.
Power BI is a powerful tool that enables users to visualize and analyze data in a variety of ways. One of the key features of Power BI is its ability to connect to a wide range of data sources, including Azure Table Storage. In this article, we will explore how to use Power Query M Language code for connecting to the Azure Table Storage data source from inside Power BI.
Power BI is a powerful business intelligence tool that allows data analysts to create interactive reports and visualizations. One of the key features of Power BI is the ability to connect to various data sources, including the EQuIS data source. EQuIS is a database management system that is widely used in the environmental industry to store and manage environmental data.
