This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementSend to Power BIThis 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.
Options
Authentication
Dataset
Popular Predecessors
- Excel Writer6 %
- Column Filter6 %
Excel Sheet Appender (XLS)5 %File Reader4 %Row Filter (deprecated)4 %- String Manipulation3 %
Joiner3 %- String to Number3 %
- Concatenate2 %
- Sorter2 %
CSV Reader2 %- GroupBy2 %
- RowID2 %
- Math Formula2 %
- Number to String2 %
- Java Snippet (simple)2 %
- Missing Value1 %
Column Rename1 %- k-Means1 %
- Table Manipulator1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Variable Loop End< 1 %
- Column Aggregator< 1 %
Table Reader< 1 %- Table Creator< 1 %
- Top k Row Filter< 1 %
- DB Reader< 1 %
Excel Reader (XLS)< 1 %- Table View (JavaScript)< 1 %
- String to Date&Time< 1 %
- Spark to Table< 1 %
- Excel Reader< 1 %
Loop End< 1 %- Naive Bayes Predictor< 1 %
Scorer< 1 %- Constant Value Column< 1 %
- Scatter Plot (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %Variable Loop End< 1 %- Column Combiner< 1 %
- Column Rename (Regex)< 1 %
- Column Resorter< 1 %
- Reference Column Filter< 1 %
- Row Sampling< 1 %
- Table Transposer< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Data Generator< 1 %
- DB Query Reader< 1 %
Tableau Writer (TDE)< 1 %- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Coordinate to Latitude/Longitude< 1 %
- Create Collection Column< 1 %
Table Row to Variable< 1 %- Auto-Binner< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- DB GroupBy< 1 %
- Column Expressions (legacy)< 1 %
- Credentials Configuration< 1 %
- Credentials Input (legacy)< 1 %
- CSV Reader< 1 %
- Scorer< 1 %
- Partitioning< 1 %
- Color Manager< 1 %
- DB Writer< 1 %
- Python Script (legacy)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %Database Reader< 1 %Simple File Reader< 1 %List Files< 1 %- Cluster Assigner< 1 %
- Regression Predictor< 1 %
- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Table Validator< 1 %
- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Pivot< 1 %
- Column Filter (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- Number Rounder< 1 %
- String Manipulation (Multi Column)< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Filter< 1 %
- Data Explorer< 1 %
- Kruskal-Wallis Test< 1 %
CASE Switch Data (End)< 1 %- Crosstab< 1 %
- Lift Chart (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Molecule Type Cast< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- DB Merge< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- 2D Density Plot (Plotly)< 1 %
- H2O Statistics< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- MDF Reader< 1 %
Excel Writer (XLS)< 1 %- TF< 1 %
- String Matcher< 1 %
- Document Data Extractor< 1 %
- Weka Cluster Assigner (3.7)< 1 %
Google Analytics Query (deprecated)< 1 %- Google Sheets Reader< 1 %
- Tag Cloud (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Table to JSON< 1 %
- JSON to Table< 1 %
- LIME Loop Start< 1 %
- GET Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Twitter Search (legacy)< 1 %
- XPath< 1 %
- Google Address Geocoder< 1 %
- File Meta Info (legacy)< 1 %
- Wait...< 1 %
- Try (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
- Chunk Loop Start< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
- Case Converter< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Missing Value Column Filter< 1 %
- Joiner< 1 %
- Normalizer< 1 %
- Number to String (PMML)< 1 %
- Rank< 1 %
Send to Power BI< 1 %- Tika Parser< 1 %
- RSS Feed Reader< 1 %
Transfer Files< 1 %- JPMML Classifier< 1 %
- Scorer (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Salesforce Simple Query< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Time< 1 %
- Time Generator (legacy)< 1 %
- SMARTS Query< 1 %
Views
- This node has no views
Workflows
ETL_homeworkKNIME Hub- ETL_homeworkKNIME Hub
- Homework_Input-OutputKNIME Hub
- KM4AllBIKNIME Hub
- Session_04_demo_othervisualtoolsKNIME Hub
- Show all 15 workflows
Links
- Looking to add rows corresponding to each unique column headerby AnotherFraudUser on 2021-05-31forum.knime.com/p/125078
- Need A Sanity Check: Persistent Unique IDby Haystack on 2019-12-15forum.knime.com/p/77043
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.