pbiCreateDatasetFromDataFrame: Create a new dataset from a data frame.

In olfrost/poweRbi: A httr wrapper for the Power BI REST API

Description

Requires the correct metadata information to be passed to the function in the form of lists and named variables. Relationships, measures and columns can be handled.

Usage

pbiCreateDatasetFromDataFrame(name, df, tableName, duplicate = FALSE,
  addRows = TRUE, datasetType = "Push", FIFO = "none", verbose = FALSE)

Arguments

name	The name of the new dataset.
df	A data frame to determine the table schema. Uses pbiGenerateTableSchema to infer the data types and creates a JSON object.
tableName	An character vector for a table name (max 1 table created per call)
duplicate	When TRUE, it will create a separate dataset with the same name as another dataset.
addRows	When TRUE, it will create the schema and data. When FALSE, just the schema will be created.
datasetType	What kind of dataset do you want to use? Use pbiDatasetTypes to see the available options.
FIFO	Default retention policy, or basic "first-in-first-out". Dataset will store between 200-210k rows and remove the oldest rows when the storage limit has been reached. Consider this option for streaming datasets. Options are 'none' or 'basicFIFO'.
verbose	If TRUE, return extra information about the endpoint.

Value

HTTP response object.

Examples

## Not run: pbiCreateDatasetFromDataFrame("New Dataset", df = cars, tableName = "Cars")

olfrost/poweRbi documentation built on May 6, 2019, 6:05 p.m.