Kyligence
Power Query is a powerful tool in Power BI that allows data analysts and business intelligence professionals to connect to various data sources, transform data, and load it into Power BI. The M language is the backbone of Power Query, and it is responsible for data transformation and data loading processes. Power Query supports various data sources, including databases, web services, and data files. In this article, we will discuss how to connect to the Kyligence data source using Power Query M language code from inside Power BI.
What is Kyligence?
Before we dive into the details of connecting to the Kyligence data source, let’s first understand what Kyligence is. Kyligence is an AI-assisted analytics platform that enables businesses to get insights from massive amounts of data quickly. Kyligence uses Apache Kylin as its core engine, which means that it supports SQL-based data warehousing and OLAP analytics. Kyligence is an enterprise-grade solution that provides high-performance analytics, data discovery, and data visualization capabilities.
Connecting to the Kyligence Data Source using Power Query M Language Code
To connect to the Kyligence data source from inside Power BI, we need to use the Power Query M language code. Power Query M is a functional programming language that is used in the Power Query editor. The M language code is used to transform and load data from various data sources into Power BI. Here are the steps to connect to the Kyligence data source using Power Query M language code:
1. Open Power BI desktop and click on the “Get Data” button on the Home tab.
2. In the “Get Data” window, search for “Web” and select “Web” from the list of available data sources.
3. In the “From Web” window, enter the URL of your Kyligence server’s REST API endpoint in the “URL” field. For example, if your Kyligence server’s REST API endpoint is “http://Kyligence-server:7070/kylin/api”, enter this URL in the “URL” field.
4. Click on the “OK” button to proceed.
5. In the “Navigator” window, select the “Kyligence” endpoint and click on the “Edit” button.
6. In the “Query Editor” window, click on the “Advanced Editor” button.
7. In the “Advanced Editor” window, replace the existing M language code with the following code:
let
Source = Json.Document(Web.Contents(“http://Kyligence-server:7070/kylin/api/cubes”)),
cubes = Source[cubes],
#”Converted to Table” = Table.FromList(cubes, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#”Expanded Column1″ = Table.ExpandRecordColumn(#”Converted to Table”, “Column1”, {“name”, “project”}, {“Column1.name”, “Column1.project”}),
#”Renamed Columns” = Table.RenameColumns(#”Expanded Column1″,{{“Column1.name”, “CubeName”}})
in
#”Renamed Columns”
8. Replace the URL “http://Kyligence-server:7070/kylin/api/cubes” with the URL of your Kyligence server’s REST API endpoint.
9. Click on the “Done” button to close the “Advanced Editor” window.
10. Click on the “Close & Apply” button to load the data into Power BI.
Conclusion
Connecting to the Kyligence data source from inside Power BI using Power Query M language code is a straightforward process. Power Query M language code is a powerful tool that enables data analysts and business intelligence professionals to connect to various data sources, transform data, and load it into Power BI. Kyligence is an enterprise-grade analytics platform that provides high-performance analytics, data discovery, and data visualization capabilities. By using Power Query M language code, we can easily connect to the Kyligence data source and analyze our data in Power BI.
