Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Send to Power BI
NodeNode / Sink

Send to Power BI

Tools & Services Microsoft Power BI
Drag & drop
Like
Copy short link

This node sends the input table to Microsoft Power BI.

The node only uploads columns that are supported by Power BI. Other columns are ignored. The supported types are String, Number (integer), Number (long), Number (double), Boolean value, Local Date, and Local Date Time. The node uploads rows in chunks to Microsoft Power BI. If the node is canceled, the already uploaded rows will remain in the Power BI dataset. Use the "Microsoft Authentication" node to connect to your Microsoft account. The KNIME Analytics Platform Azure Application needs the following permissions for this node:
  • View all datasets : Needed to check if a dataset already exists in your Power BI workspace.
  • Read and write all datasets : Needed to upload a table to a Power BI dataset in your workspace.
  • View all workspaces : Needed to get the identifier of the selected Power BI workspace.
  • Maintain access to data you have given it access to : Needed to access the Power BI API during the node execution without asking you to log in again.
Note: The Power BI REST API has some limitations in terms of the size of a dataset and the number of rows that can be shipped per hour. For more information visit the documentation.

Node details

Input ports
  1. Type: Microsoft Credential
    Microsoft Connection
    Microsoft Connection that provides user authentication.
  2. Type: Table
    Table
    Data to be send to Power BI.
input (Dynamic Inport)
Additional data to be send to your data set.
  1. Type: Table

Extension

The Send to Power BI node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    KBL: Preparing data for Spotfire
    Education KNIMEPress Reporting
    +3
    Calculating money used, assigned and remaining for each project by year, to generate a da…
    hayasaka > Public > KNIMEPress > KNIME_Beginners_Luck_4.4_20210802 > BeginnersLuck > Chapter7 > Export_to_PowerBI
    hayasaka
  2. Go to item
    KBL: Preparing data for Spotfire
    Education KNIMEPress Reporting
    +3
    Calculating money used, assigned and remaining for each project by year, to generate a da…
    hayasaka > Public > KNIMEPress > KNIME_Beginners_Luck_4.5_20220114 > BeginnersLuck > Chapter7 > Export_to_PowerBI
    hayasaka
  3. Go to item
    KBL: Preparing data for Spotfire
    Education KNIMEPress Reporting
    +3
    Calculating money used, assigned and remaining for each project by year, to generate a da…
    hayasaka > Public > KNIMEPress > KNIME_Beginners_Luck_4.6_20220802 > BeginnersLuck > Chapter7 > Export_to_PowerBI
    hayasaka
  4. Go to item
    KBL: Preparing data for Spotfire
    Education KNIMEPress Reporting
    +3
    Calculating money used, assigned and remaining for each project by year, to generate a da…
    joli > Public > BeginnersLuck > Chapter7 > Export_to_PowerBI
    joli
  5. Go to item
    Date Table Generator
    Date time Date Table Date Table Knime
    +2
    Enter Start Date and End Date, this workflow will calculate date table with all the metad…
    brkylmz > BI-FI BUSINESS KNIME PROJECTS > Date Table Generator
    brkylmz
  6. Go to item
    Advanced Example of Reporting with BIRT
    Reporting BIRT
    Input data set contains inspection scores for local restaurants. Final report includes: -…
    enekogonzalezme > Public > 08_BIRT_Example_Advanced
    enekogonzalezme
  7. Go to item
    ML Pipeline with Spark Streaming
    hazirafidi > Public > Big Data > ML Pipeline with Spark Streaming
    hazirafidi
  8. Go to item
    ADVANCED WEB SCRAPER FOR H&M GERMANY
    Web scraper Web scraping Retail Competitor Analysis
    +4
    ADVANCED WEB SCRAPER FOR H&M GERMANY This workflow, connects to the and H&M Germany websi…
    brkylmz > BI-FI BUSINESS KNIME PROJECTS > Advanced Web Scraper for H&M
    brkylmz
  9. Go to item
    KPB 1 TESTING
    septia1509 > Public > KPB 1 TESTING
    septia1509
  10. Go to item
    Web Application for the ARR Analysis
    Finance ARR
    This workflow creates a small web application for the ARR calculation and analysis from c…
    kathrin > Forum Questions > Web Application for the ARR Analysis Power BI
    kathrin

No known nodes available

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits