Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Send to Power BI (deprecated)
NodeNode / Sink

Send to Power BI (deprecated)

Tools & Services Microsoft Power BI

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

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. 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. 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 (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    KM4AllBI
    x010219 > Public > KM4AllBI
  3. Go to item
    Test_project
    gregstone > Public > Test_project
  4. Go to item
    Test_project
    walterthompson > Public > Test_project
  5. Go to item
    Visualizing_Customer_Data_With_R_JS_PowerBI
    stelfrich > Public > Visualizing_Customer_Data_With_R_JS_PowerBI
  6. Go to item
    Visualizing_Customer_Data_With_R_JS_PowerBI
    kathrin > Educator Meeting Summit > Visualizing_Customer_Data_With_R_JS_PowerBI
  7. Go to item
    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.…
    knime > Education > Courses > L4-TP Introduction to Text Processing > Supplementary Workflows > TextMining_IS_Literature_BoW_LDA
  8. Go to item
    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.…
    scottf > Public > TextMiningWebinar > TextMining_IS_Literature_BoW_LDA
  9. Go to item
    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.…
    scottf > Public > TextMining_IS_Literature_BoW_LDA
  10. Go to item
    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.…
    huds_gfm18 > Public > TextMiningWebinar > TextMining_IS_Literature_BoW_LDA

No known nodes available

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
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits