Exports consonance function data in formats optimized for Power BI visualization and analysis.
export_for_powerbi(data, file, format = NULL, include_metadata = TRUE,
pivot = FALSE)A concurve object or intervals data frame.
Output file path. Supports .csv, .xlsx, or .json extensions.
Output format: "csv" (default), "excel", or "json". If NULL, inferred from file extension.
Logical. If TRUE, includes additional metadata columns useful for Power BI DAX measures. Default is TRUE.
Logical. If TRUE, creates a pivoted format with separate columns for lower and upper bounds at each confidence level. Default is FALSE.
Invisibly returns the exported data frame.
This function prepares consonance function data for import into Power BI. The exported data includes:
Confidence levels and corresponding intervals
P-values and S-values
Interval widths for precision analysis
When include_metadata = TRUE, adds columns for:
ci_label: Human-readable confidence level (e.g., "95\
significance: Whether interval excludes null value
curve_table() for formatted interval tables
curve_snowflake() for Snowflake database integration
if (FALSE) { # \dontrun{
# Generate consonance data
model <- lm(mpg ~ wt, data = mtcars)
result <- curve_gen(model, "wt")
# Export to CSV for Power BI
export_for_powerbi(result[[1]], "consonance_data.csv")
# Export with metadata
export_for_powerbi(result[[1]], "consonance_data.csv", include_metadata = TRUE)
# Export to Excel
export_for_powerbi(result[[1]], "consonance_data.xlsx", format = "excel")
} # }