Package: qiverse.powerbi 0.0.1.0
Healthcare Quality Intelligence Unit (Western Australia Health)
qiverse.powerbi: PowerBI Connectivity
Defines functions needed to connect to PowerBI dataflows/datasets.
Authors:
qiverse.powerbi_0.0.1.0.tar.gz
qiverse.powerbi_0.0.1.0.zip(r-4.5)qiverse.powerbi_0.0.1.0.zip(r-4.4)qiverse.powerbi_0.0.1.0.zip(r-4.3)
qiverse.powerbi_0.0.1.0.tgz(r-4.5-any)qiverse.powerbi_0.0.1.0.tgz(r-4.4-any)qiverse.powerbi_0.0.1.0.tgz(r-4.3-any)
qiverse.powerbi_0.0.1.0.tar.gz(r-4.5-noble)qiverse.powerbi_0.0.1.0.tar.gz(r-4.4-noble)
qiverse.powerbi_0.0.1.0.tgz(r-4.4-emscripten)qiverse.powerbi_0.0.1.0.tgz(r-4.3-emscripten)
qiverse.powerbi.pdf |qiverse.powerbi.html✨
qiverse.powerbi/json (API)
| # Install 'qiverse.powerbi' in R: |
| install.packages('qiverse.powerbi', repos = c('https://aus-doh-safety-and-quality.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/aus-doh-safety-and-quality/qiverse/issues
Last updated 17 hours agofrom:993a603e5a (on main). Checks:1 OK, 8 WARNING. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Apr 02 2025 |
| R-4.5-win | WARNING | Apr 02 2025 |
| R-4.5-mac | WARNING | Apr 02 2025 |
| R-4.5-linux | WARNING | Apr 02 2025 |
| R-4.4-win | WARNING | Apr 02 2025 |
| R-4.4-mac | WARNING | Apr 02 2025 |
| R-4.4-linux | WARNING | Apr 02 2025 |
| R-4.3-win | WARNING | Apr 02 2025 |
| R-4.3-mac | WARNING | Apr 02 2025 |
Exports:download_dataflow_tabledownload_dataset_tabledownload_dataset_table_restexecute_rest_queryexecute_xmla_querylist_datasetslist_workspacesmount_dataflow_table
Dependencies:askpassbitbit64clicliprcpp11crayoncurldata.tabledplyrfansigenericsgluehmshttrjsonlitelifecyclemagrittrmimeopensslpillarpkgconfigprettyunitsprogresspurrrR6readrrlangstringistringrsystibbletidyselecttzdbutf8uuidvctrsvroomwithrxml2
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| The qiverse.powerbi package. | qiverse.powerbi-package qiverse.powerbi |
| Download PowerBI Dataflow Table | download_dataflow_table |
| Download a specified dataset table into R using either the XMLA or REST API endpoints. This is a convenience wrapper around the 'execute_xmla_query()' and 'execute_rest_query()' functions. | download_dataset_table |
| This is the main function to be used. Specify the name of workspace, dataset, and target table, and this function will query the API and return the table as a data.frame | download_dataset_table_rest |
| Execute a DAX query against a specified PowerBI Dataset using the REST API endpoint. | execute_rest_query |
| Execute a DAX query against a specified PowerBI Dataset using the XMLA API endpoint. | execute_xmla_query |
| Request metadata for all datasets in specified workspace | list_datasets |
| Request metadata for all Workspaces in Tenant | list_workspaces |
| Mount a PowerBI Dataflow Table as a Databricks External Table | mount_dataflow_table |
