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

Send to Power BI

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. Important: When choosing the Node credentials storage location, the node saves a refresh token with access to your Microsoft account (with the specified permissions) in the node settings. Before sharing the workflow, you should clear your credentials in the node dialog. The KNIME Analytics Platform Azure Application needs the following permissions:
  • 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. Table Type: Data
    Data to be send to Power BI.
Dynamic input ports
  1. input Type: Data
    Additional data to be send to your data set.

Related workflows & nodes

  1. Session_04_demo_othervisualtools
    visualization tableau powerbi +1
    Export data to Power BI and Tableau
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_10.2020 > L4-DV Codeless Data Exploration and Visualization - Demos > Session4_demo > Session_04_demo_othervisualtools
  2. KM4AllBI
    x010219 > Public > KM4AllBI
  3. Visualizing_Customer_Data_With_R_JS_PowerBI
    stelfrich > Public > Visualizing_Customer_Data_With_R_JS_PowerBI
  4. Visualizing_Customer_Data_With_R_JS_PowerBI
    kathrin > Educator Meeting Summit > Visualizing_Customer_Data_With_R_JS_PowerBI
  5. IS Literature Mining with Topic Detection (LDA)
    topic detection text summarization LDA +3
    This workflow shows how to extract topics from the input data presented as an Excel file. It uses the Topic Extractor n…
    knime > Education > Courses > L4-TP Introduction to Text Processing > Supplementary Workflows > TextMining_IS_Literature_BoW_LDA
  6. IS Literature Mining with Topic Detection (LDA)
    topic detection text summarization LDA +3
    This workflow shows how to extract topics from the input data presented as an Excel file. It uses the Topic Extractor n…
    scottf > Public > TextMiningWebinar > TextMining_IS_Literature_BoW_LDA
  7. IS Literature Mining with Topic Detection (LDA)
    topic detection text summarization LDA +3
    This workflow shows how to extract topics from the input data presented as an Excel file. It uses the Topic Extractor n…
    scottf > Public > TextMining_IS_Literature_BoW_LDA
  8. IS Literature Mining with Topic Detection (LDA)
    topic detection text summarization LDA +3
    This workflow shows how to extract topics from the input data presented as an Excel file. It uses the Topic Extractor n…
    huds_gfm18 > Public > TextMiningWebinar > TextMining_IS_Literature_BoW_LDA
  9. Financial Reporting Variance Analysis
    variance analysis excel finance +9
    This workflow demonstrates a typical variance analysis report created by Finance teams. The process identifies correspo…
    supersharp > Finance_Public > Financial Reporting Variance Analysis > Financial Reporting Variance Analysis
  10. ETL_homework
    phyominthant > Public > ETL_homework

No known nodes available

Extension

This node is part of the extension

KNIME Power BI IntegrationTrusted extension
Version 4.3.0
Short link

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 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 Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits