The item facilitates authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more
Collection
KNIME for Microsoft Fabric Users
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.
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.
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.
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.
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.
Go to item
Workflow
Generates and updates reports in Power BI.
Examples40_Partners01_MicrosoftPowerBI
0