Cognite Data Fusion
Power BI is a powerful business intelligence tool that allows users to visualize their data in a meaningful way. One of the key features of Power BI is the ability to connect to various data sources, including Cognite Data Fusion. In this article, we will explore how to use Power Query M Language code to connect to the Cognite Data Fusion data source from inside Power BI.
What is Cognite Data Fusion?
Cognite Data Fusion is a cloud-based data integration platform that provides a unified view of industrial data. It enables companies to extract value from their data by connecting siloed systems, making data accessible and usable, and unlocking insights that can lead to better decision-making.
What is Power Query M Language Code?
Power Query M Language is a functional language used to query and transform data in Power BI. It is a powerful tool for data wrangling and can be used to connect to various data sources.
Connecting to Cognite Data Fusion Data Source from Inside Power BI
To connect to Cognite Data Fusion from inside Power BI, we will need to use the Power Query M Language code. Here are the steps to do that:
Step 1: Open Power BI Desktop
First, open Power BI Desktop and click on the “Get Data” button on the Home tab.
Step 2: Select Cognite Data Fusion as a Data Source
Next, select “Cognite Data Fusion” as the data source and click on “Connect.”
Step 3: Enter API Key and Project Name
You will be prompted to enter your API key and project name. Once you have entered this information, click on “OK.”
Step 4: Write Power Query M Language Code
Now, we will write the Power Query M Language code to connect to the Cognite Data Fusion data source. Here is an example code snippet:
let
Source = Cognite.DataFusion(),
#”Filtered Rows” = Table.SelectRows(Source, each ([Name] = “MyTable”)),
#”Expanded Data” = Table.ExpandRecordColumn(#”Filtered Rows”, “Data”, {“MyColumn1”, “MyColumn2”}),
in
#”Expanded Data”
This code snippet connects to the Cognite Data Fusion data source, filters the rows to only include the table named “MyTable”, and expands the “Data” column to include columns named “MyColumn1” and “MyColumn2”.
Step 5: Load Data into Power BI
Once you have written your Power Query M Language code, click on “Close & Apply” to load the data into Power BI.
Conclusion
In this article, we have explored how to use Power Query M Language code to connect to the Cognite Data Fusion data source from inside Power BI. By following the steps outlined above, you can extract valuable insights from your industrial data and make better decisions. Power BI and Cognite Data Fusion are powerful tools that, when used together, can provide a unified view of your data and unlock new possibilities.
