{
  "_id": "6acdc91fa14063b82c3aca1b",
  "Package": "qiverse.powerbi",
  "Title": "PowerBI Connectivity",
  "Version": "0.0.19",
  "Authors@R": "person(given = \"Healthcare Quality Intelligence Unit (Western Australia Health)\",\nfamily = \"\",\nrole = c(\"aut\", \"cre\"),\nemail = \"safetyandquality@health.wa.gov.au\")",
  "Description": "Defines functions needed to connect to PowerBI\ndataflows/datasets.",
  "License": "GPL (>= 3) + file LICENSE",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "URL": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/qiverse.powerbi",
  "BugReports": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/issues",
  "VignetteBuilder": "knitr",
  "Config/roxygen2/version": "8.1.0",
  "Additional_repositories": "https://aus-doh-safety-and-quality.r-universe.dev/",
  "Config/pak/sysreqs": "libssl-dev",
  "Repository": "https://aus-doh-safety-and-quality.r-universe.dev",
  "Date/Publication": "2026-10-13 05:53:40 UTC",
  "RemoteUrl": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse",
  "RemoteRef": "main",
  "RemoteSha": "1ff4db8172ea61894a9627246e65e4850155496f",
  "RemoteSubdir": "qiverse.powerbi",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-13 05:58:08 UTC",
    "User": "root"
  },
  "Author": "Healthcare Quality Intelligence Unit (Western Australia Health) [aut,\ncre]",
  "Maintainer": "Healthcare Quality Intelligence Unit (Western Australia Health) <safetyandquality@health.wa.gov.au>",
  "_user": "aus-doh-safety-and-quality",
  "_type": "src",
  "_file": "qiverse.powerbi_0.0.19.tar.gz",
  "_fileid": "https://r2.ropensci.org/af531dbde7e5e8b84f038dedae826ea773d9e92635dd1fb3c61864f15a098888",
  "_filesize": 127620,
  "_sha256": "af531dbde7e5e8b84f038dedae826ea773d9e92635dd1fb3c61864f15a098888",
  "_expires": "2027-01-21T06:01:01.000Z",
  "_created": "2026-10-13T05:58:08.000Z",
  "_published": "2026-10-13T06:01:03.490Z",
  "_buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 115153082058,
      "time": 135,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11792016765"
    },
    {
      "job": 115153081967,
      "time": 122,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11792186388"
    },
    {
      "job": 115153082092,
      "time": 95,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11791804367"
    },
    {
      "job": 115153082040,
      "time": 123,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11792161438"
    },
    {
      "job": 115152103650,
      "time": 212,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11792445696"
    },
    {
      "job": 115153081988,
      "time": 91,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11791779308"
    },
    {
      "job": 115153082052,
      "time": 78,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11791769348"
    },
    {
      "job": 115153082071,
      "time": 62,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11791564618"
    },
    {
      "job": 115153082101,
      "time": 56,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11792640111"
    }
  ],
  "_upstream": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse",
  "_commit": {
    "id": "1ff4db8172ea61894a9627246e65e4850155496f",
    "author": "Andrew Johnson <andrew.johnson@arjohnsonau.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #64 from AUS-DOH-Safety-and-Quality/pbi-df-metadata\n\nMove PBI dataflow metadata parsing into qiverse.powerbi",
    "time": 1791870820
  },
  "_maintainer": {
    "name": "Healthcare Quality Intelligence Unit (Western Australia Health)",
    "email": "safetyandquality@health.wa.gov.au",
    "login": "dohwahqiu",
    "description": "",
    "uuid": 95904605
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "httr",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "qiverse.azure",
      "role": "Suggests"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "zlib",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "aus-doh-safety-and-quality",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-44",
      "n": 4
    },
    {
      "week": "2025-45",
      "n": 3
    },
    {
      "week": "2025-47",
      "n": 3
    },
    {
      "week": "2025-50",
      "n": 1
    },
    {
      "week": "2026-02",
      "n": 1
    },
    {
      "week": "2026-03",
      "n": 4
    },
    {
      "week": "2026-04",
      "n": 4
    },
    {
      "week": "2026-14",
      "n": 1
    },
    {
      "week": "2026-20",
      "n": 3
    },
    {
      "week": "2026-22",
      "n": 3
    },
    {
      "week": "2026-24",
      "n": 1
    },
    {
      "week": "2026-25",
      "n": 4
    },
    {
      "week": "2026-29",
      "n": 1
    },
    {
      "week": "2026-33",
      "n": 2
    },
    {
      "week": "2026-38",
      "n": 2
    },
    {
      "week": "2026-41",
      "n": 1
    },
    {
      "week": "2026-42",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 5,
  "_contributors": [
    {
      "user": "andrjohns",
      "count": 123,
      "uuid": 27717896
    },
    {
      "user": "pli9",
      "count": 26,
      "uuid": 43059710
    },
    {
      "user": "nmhs-mikikochono-schaa",
      "count": 12,
      "uuid": 172719753
    },
    {
      "user": "kyrantgs",
      "count": 4,
      "uuid": 43620527
    },
    {
      "user": "fraser-clarke",
      "count": 2,
      "uuid": 99302738
    }
  ],
  "_userbio": {
    "uuid": 65321745,
    "type": "organization",
    "name": "WA Health - Safety & Quality",
    "followers": 57,
    "description": "Western Australia, Department of Health"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/qiverse.powerbi"
  },
  "_devurl": "https://github.com/aus-doh-safety-and-quality/qiverse",
  "_searchresults": 2,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/qiverse.powerbi.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "decompress_string",
    "download_dataflow_table",
    "download_dataset_table",
    "execute_arrow_query",
    "execute_rest_query",
    "execute_xmla_query",
    "list_dataflows",
    "list_datasets",
    "list_workspaces",
    "refresh_dataflow",
    "update_dataflow_compute_engine",
    "update_dataset_storage_mode"
  ],
  "_help": [
    {
      "page": "qiverse.powerbi-package",
      "title": "The qiverse.powerbi package.",
      "topics": [
        "qiverse.powerbi-package",
        "qiverse.powerbi"
      ]
    },
    {
      "page": "decompress_string",
      "title": "Decode a PowerBI Compressed String",
      "topics": [
        "decompress_string"
      ]
    },
    {
      "page": "download_dataflow_table",
      "title": "Download PowerBI Dataflow Table",
      "topics": [
        "download_dataflow_table"
      ]
    },
    {
      "page": "download_dataset_table",
      "title": "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.",
      "topics": [
        "download_dataset_table"
      ]
    },
    {
      "page": "execute_arrow_query",
      "title": "Execute a DAX query against a specified PowerBI Dataset using the REST Arrow API endpoint.",
      "topics": [
        "execute_arrow_query"
      ]
    },
    {
      "page": "execute_rest_query",
      "title": "Execute a DAX query against a specified PowerBI Dataset using the REST API endpoint.",
      "topics": [
        "execute_rest_query"
      ]
    },
    {
      "page": "execute_xmla_query",
      "title": "Execute a DAX query against a specified PowerBI Dataset using the XMLA API endpoint.",
      "topics": [
        "execute_xmla_query"
      ]
    },
    {
      "page": "list_dataflows",
      "title": "Request metadata for all dataflows in specified workspace",
      "topics": [
        "list_dataflows"
      ]
    },
    {
      "page": "list_datasets",
      "title": "Request metadata for all datasets in specified workspace",
      "topics": [
        "list_datasets"
      ]
    },
    {
      "page": "list_workspaces",
      "title": "Request metadata for all Workspaces in Tenant",
      "topics": [
        "list_workspaces"
      ]
    },
    {
      "page": "refresh_dataflow",
      "title": "Refresh PowerBI Dataflow",
      "topics": [
        "refresh_dataflow"
      ]
    },
    {
      "page": "update_dataflow_compute_engine",
      "title": "Update PowerBI Dataflow compute engine behaviour",
      "topics": [
        "update_dataflow_compute_engine"
      ]
    },
    {
      "page": "update_dataset_storage_mode",
      "title": "Update PowerBI Semantic Model (Dataset) storage mode",
      "topics": [
        "update_dataset_storage_mode"
      ]
    }
  ],
  "_readme": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/raw/main/qiverse.powerbi/README.md",
  "_rundeps": [
    "askpass",
    "curl",
    "httr",
    "jsonlite",
    "mime",
    "openssl",
    "R6",
    "sys"
  ],
  "_vignettes": [
    {
      "source": "powerbi.Rmd",
      "filename": "powerbi.html",
      "title": "PowerBI Dataflows and Datasets",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Download PowerBI Dataflow Table",
        "Download PowerBI Dataset Table"
      ],
      "created": "2025-03-25 02:00:44",
      "modified": "2026-01-20 01:55:29",
      "commits": 2
    }
  ],
  "_score": 5.230448921378274,
  "_indexed": true,
  "_nocasepkg": "qiverse.powerbi",
  "_universes": [
    "aus-doh-safety-and-quality",
    "dohwahqiu"
  ],
  "_previous": "0.0.18",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.19",
      "date": "2026-10-13T06:00:25.000Z",
      "distro": "resolute",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/e0c5b0ac937e8790fec35da4c089d8e06e14d8c813d1bdd7c0f19f423cefa387",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.0.19",
      "date": "2026-10-13T06:00:18.000Z",
      "distro": "resolute",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/0c2982600f72ca1c0ed623e92a4100b578fdf954c81df6c02a24d324d7101a27",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.19",
      "date": "2026-10-13T05:59:57.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/7a1ab01885ceb13a460b699d71da703003d9ecceeb641da62ee4b619ffde2d8c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.0.19",
      "date": "2026-10-13T06:00:22.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/47e214c4714d4ed4a78ad625c153ef65da5a9a881c7116b41100c8bc6907db95",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.19",
      "date": "2026-10-13T05:59:56.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/fb1e603831ac0e72ee6789395a018df78bc2d4409867b202d853b0e0879f7c2a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-13T05:59:24.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/3d7ebd6207ae021da919c2b32e3fb06596202f643c9d17fdb04650153c41fe12",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-13T05:59:12.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/1346fb8c22fcc76a0d6f94cc2f0db56fb2fda2987f7538db5975465ddcb095ed",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.0.19",
      "date": "2026-10-13T05:59:10.000Z",
      "commit": "1ff4db8172ea61894a9627246e65e4850155496f",
      "fileid": "https://r2.ropensci.org/837847ead61d56a2095c95be384ad66dec823a0d85911be043bd8eddc045f886",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/38353827395"
    }
  ]
}