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.
![Get Data Window](get-data.png)
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.
![Advanced Options Window](advanced-options.png)
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”.
![New Source Window](new-source.png)
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, businesses require robust tools to extract meaningful insights from their vast amounts of data. Business Intelligence (BI) has become a vital component for organizations aiming to gain a competitive edge. One such powerful BI tool is Microsoft Power BI, which enables users to analyze, visualize, and share data effortlessly. To unlock the full potential of Power BI, understanding and utilizing measures is crucial. In this article, we will delve into the world of measures in Power BI and explore how they can elevate your business intelligence efforts.
Power Query is a powerful tool that enables users to transform and shape data within Microsoft Excel and Power BI. It provides a user-friendly interface and a comprehensive set of features to handle complex data manipulation tasks. One essential aspect of Power Query is the ability to organize and modify data using Query Steps. In this article, we will focus specifically on the technique of renaming Query Steps and how it can revolutionize your data transformations.
In today’s fast-paced digital world, data plays a crucial role in decision-making processes. Microsoft Excel has been a go-to tool for managing and analyzing data for years, and its capabilities are continually expanding. One powerful feature that often goes unnoticed is Power Query. This tool empowers users to manipulate and transform data with ease. In this article, we will explore how you can unlock the hidden potential of Power Query by learning how to remove total rows in Excel tables efficiently.
Power BI has revolutionized the world of data analysis and visualization, empowering businesses to make informed decisions based on meaningful insights. However, even with its robust features, there are instances where traditional functions fall short in meeting complex data processing requirements. Enter X Functions, a game-changing addition to Power BI that unlocks a new level of data manipulation and analysis capabilities. In this article, we will delve into the world of X Functions, exploring their benefits, implementation techniques, best practices, and real-world applications.
Power Query is a data connectivity tool in Microsoft Excel and Power BI that allows users to search, connect to, and transform data from a wide variety of sources. One such source is the Statistical Information System Collaboration Community (SIS-CC) SDMX Data Source. In this article, we will explore the Power Query M Language code needed to connect to the SIS-CC SDMX Data Source from inside Power BI.
Why Power BI Certification Matters In today’s digital age, data is the lifeblood of any successful organization. It holds the key to making informed decisions, identifying trends, and gaining a competitive edge. However, without the right tools and knowledge, data can be overwhelming and challenging to navigate. This is where Power BI comes in. Power…