Access Data and Metadata from 'Microsoft' 'Power BI' Documents

Access data and metadata from 'Microsoft' 'Power BI' ('.pbix', < https://powerbi.microsoft.com>) documents with R. The 'pbixr' package enables one to extract 'Power Query M' formulas (< https://docs.microsoft.com/en-us/power-query/>) and 'Data Analysis Expressions' ('DAX', < https://docs.microsoft.com/en-us/dax/>) queries and their properties, report layout and style, and data and data models.


News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("pbixr")

0.1.3 by Don Diproto, 4 months ago


https://github.com/pbixr/pbixr


Report a bug at https://github.com/pbixr/pbixr/issues


Browse source code at https://github.com/cran/pbixr


Authors: Don Diproto [aut, cre]


Documentation:   PDF Manual  


GPL-3 license


Imports formatR, xml2, jsonlite, zip, utils, textclean, stringr

Depends on dplyr

Suggests knitr, rmarkdown, testthat, RCurl, ggplot2, ggraph, igraph, imager, tidyr

System requirements: 'Microsoft' 'PowerShell' (<https://docs.microsoft.com/en-us/powershell/>), 'Microsoft' 'Power BI' (<https://powerbi.microsoft.com>)


See at CRAN