Hub
Pricing About
Collection

KNIME for Microsoft Fabric Users

MicrosoftMicrosoft FabricFabricDBDatabase
+2

Use KNIME’s intuitive, low-code/no-code interface to integrate and manipulate data in Microsoft Fabric, combine it with other sources, build visual workflows of any complexity level from data manipulation to PowerBI model creation, and share insights with others in the organization through data apps without leaving Microsoft Fabric. If needed, you have the flexibility to script custom database statements, too.

Aug 25, 2025 3:41 PM
Like

Getting Started with Microsoft Fabric Workflows

Utilizing Microsoft Fabric within KNIME requires connecting to a Fabric workspace using the Microsoft Fabric Workspace Connector node. Once connected, you can utilize the different Fabric services using dedicated connector nodes such as the Microsoft Fabric Data Warehouse Connector or the OneLake Connector as well as the Power BI Model Reader node. The connector nodes then are combined with KNIME DB and file handling nodes for data manipulation and file management.
Node / Source
Microsoft Authenticator

The item facilitates authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more

Node / Source
Secrets Retriever

Retrieves secrets from KNIME Hub Secrets Store for workflows. Learn more

Node / Source
Microsoft Fabric Workspace Connector

The Microsoft Fabric Workspace Connector node allows to connect to a Microsoft Fabric workspace. Learn more

Node / Source
Microsoft Fabric Data Warehouse Connector

Enables querying and processing data from a Fabric Data Warehouse using KNIME Database nodes. Learn more

Node / Source
Microsoft OneLake Connector

Establishes a connection to OneLake storage in a Microsoft Fabric workspace for downstream nodes to access, read, and write files. Learn more

Node / Source
Power BI Model Reader

Reads data from Power BI using a DAX query and supports basic data types returned by the REST API. Learn more

Node / Sink
Power BI Model Refresher

Refreshes a Power BI Semantic Model to ensure up-to-date data. Learn more

Node / Sink
Send to Power BI

Sends input table to Power BI, uploading supported columns in chunks, with permissions needed for dataset manipulation. Learn more

Go to item
Workflow
Microsoft Fabric Integration Overview
MicrosoftFabricIO
+3
Generates visual interactions with Microsoft Fabric services in KNIME Analytics Platform.
Examples40_Partners01_MicrosoftMicrosoft Fabric Integration Overview
0
knime
Microsoft Secret Types

Data Manipulation with KNIME and Microsoft Fabric

KNIME makes it easy for you to get your data into the right form within Microsoft Fabric. Using the KNIME DB nodes, you can visually create database queries and push execution to the Fabric Data Warehouse. Combining this with the local execution power of KNIME allows you to design your workflow based on where you would like the execution of different workflow pieces to take place.
Node / Source
Microsoft Authenticator

The item facilitates authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more

Node / Source
Microsoft Fabric Workspace Connector

The Microsoft Fabric Workspace Connector node allows to connect to a Microsoft Fabric workspace. Learn more

Node / Source
Microsoft Fabric Data Warehouse Connector

Enables querying and processing data from a Fabric Data Warehouse using KNIME Database nodes. Learn more

Node / Sink
DB Loader

The item loads large amounts of data into an existing database table using database specific bulk loading functionality. Learn more

Node / Source
DB Table Selector

Retrieves data from a specified database table or view. Learn more

Node / Manipulator
DB GroupBy

Groups rows by selected columns and aggregates data based on specified criteria. Learn more

Node / Manipulator
DB Joiner

This node joins two DB Data tables. The join is based on the joining columns of both tables. Learn more

Node / Manipulator
GroupBy

Groups rows of a table by unique values in selected columns and aggregates remaining columns based on specified settings. Learn more

Node / Manipulator
Joiner

The item combines two tables based on selected columns, similar to a database join operation. Learn more

Node / Source
Azure Data Lake Storage Gen2 Connector

Connects to ADLS Gen2 to access data as a file system for read/write operations. Learn more

Node / Source
Azure Blob Storage Connector

Connects to Azure Blob Storage, allowing downstream nodes to access data as a file system for various operations. Learn more

Go to item
Workflow
Fabric Data Warehouse
MicrosoftFabricIO
+1
Generates SQL statements and manipulates data within Microsoft Fabric Data Warehouses using KNIME database framework.
Examples40_Partners01_MicrosoftFabric Data Warehouse
0
knime
KNIME Database Extension Guide

File Management with KNIME and Microsoft Fabric

KNIME enables you to work with your files within the Microsoft Fabric environment. Using KNIME’s file handling nodes you can read and write various different file formats as well as manage your files.
Node / Source
Microsoft Authenticator

The item facilitates authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more

Node / Source
Microsoft Fabric Workspace Connector

The Microsoft Fabric Workspace Connector node allows to connect to a Microsoft Fabric workspace. Learn more

Node / Source
Microsoft OneLake Connector

Establishes a connection to OneLake storage in a Microsoft Fabric workspace for downstream nodes to access, read, and write files. Learn more

Node / Source
Delta Table Reader (Labs)

Reads Delta Lake tables by loading the latest snapshot of the specified table. Learn more

Node / Source
Excel Reader

The item reads Excel files and converts the data into KNIME types, providing a preview of the file content and structure. Learn more

Node / Sink
Excel Writer

Writes input data table to an Excel file, creating new or appending to existing spreadsheets in .xls or .xlsx format. Learn more

Node / Source
Transfer Files

The node transfers files from a source to a specified folder, with options to copy or move files, including subfolders, and delete source files after moving. Learn more

Node / Source
List Files/Folders

Lists files and/or folders within a selected folder from various file systems. Learn more

Node / Source
CSV Reader

Reads CSV files and auto-guesses file structure. Learn more

Node / Sink
CSV Writer

Writes input data table to a file or remote location in CSV format. Learn more

Node / Source
Parquet Reader

Reads Parquet files, supporting primitive and repeated groups with primitive values, from single files or a directory. Learn more

Node / Sink
Parquet Writer

Writes KNIME data table into Parquet file(s) in specified folder, with option to split data into multiple files. Learn more

Go to item
Workflow
Fabric OneLake
MicrosoftFabricIO
+1
Manages files in Microsoft OneLake using KNIME Analytics Platform.
Examples40_Partners01_MicrosoftFabric OneLake
0
knime
KNIME File Handling Guide

Reporting via Power BI

Using the different Power BI nodes, you can create and upload new data into Power BI models, read the data of existing models and update a report once you have updated the external data it refers to.
Node / Source
Microsoft Authenticator

The item facilitates authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more

Node / Source
Power BI Model Reader

Reads data from Power BI using a DAX query and supports basic data types returned by the REST API. Learn more

Node / Sink
Power BI Model Refresher

Refreshes a Power BI Semantic Model to ensure up-to-date data. Learn more

Node / Sink
Send to Power BI

Sends input table to Power BI, uploading supported columns in chunks; canceled uploads remain in dataset. Learn more

Go to item
Workflow
PowerBI
MicrosoftFabricMicrosoft Power BI
Generates and updates reports in Power BI.
Examples40_Partners01_MicrosoftPowerBI
0
knime

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits