Description Usage Value Note Author(s) Examples
View source: R/f_get_connections.R
A query to link an open '.pbix'(s) with relevant 'Analysis Services' connection information is developed. The query is executed via 'PowerShell'.
1 |
The '.pbix' and associated port.
An input is not required for this function. 'Power BI' and 'PowerShell' are required.
Don Diproto
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | ## Not run:
# Get dummy data ------------------------------------------------------------
# Create a temporary directory
temp_dir <- file.path(tempdir(),"functionTest")
if(!dir.exists(temp_dir)) {
dir.create(temp_dir)
}
sample_file_name <- "OR_sample_func.pbix"
pathFileSample <- file.path(temp_dir, sample_file_name)
# See if dummy data already exists in temporary directory
parent_temp_dir <- dirname(temp_dir)
existing_file <- list.files(parent_temp_dir,
pattern = sample_file_name, recursive = TRUE, full.names = TRUE)
# Download the sample .pbix if it doesn't exist
if (length(existing_file) == 0) {
url_pt1 <- "https://github.com/KoenVerbeeck/PowerBI-Course/blob/"
url_pt2 <- "master/pbix/TopMovies.pbix?raw=true"
url <- paste0(url_pt1, url_pt2)
req <- download.file(url, destfile = pathFileSample, mode = "wb")
} else {
pathFileSample <- existing_file[1]
}
# Do stuff ------------------------------------------------------------------
#
# Open the .pbix with 'Power BI' if it is not already open.
#
# Run the function
connections_open <- f_get_connections()
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.