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)
Are you looking to take your Power BI reporting game to the next level? One powerful feature you must master is the ability to pin a report page to a Power BI dashboard. Pinning a report page allows you to showcase specific visualizations and insights from your report directly on a dashboard, making it easier for you and your audience to access key information at a glance. In this article, we’ll explore the benefits, step-by-step process, best practices, and tips to help you become a pro at pinning report pages to Power BI dashboards.
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
If you are a Power BI user, you may have come across the challenge of connecting to an Essbase data source from inside Power BI. This can be a tricky task, but the good news is that it is possible using Power Query M Language. Power Query M Language is a powerful tool that can help you to transform and analyze data from a variety of sources.
In today’s competitive business landscape, sales performance plays a crucial role in determining the success and growth of organizations. To make informed decisions and drive sales effectiveness, businesses need to analyze sales data and gain valuable insights. However, relying solely on sales data may not provide a complete picture of performance without considering the budgetary aspects.
In today’s data-driven world, the ability to effectively communicate insights is paramount. Data storytelling, the art of weaving a compelling narrative around data, has become an essential skill for professionals across various industries. One powerful tool in the data visualization arsenal is the treemap, which offers a visually stunning way to present hierarchical data. In this step-by-step guide, we will explore how to design a stunning treemap using Power BI and unleash the true storytelling potential of your data.
