Skip to content

Tools for auto-documenting and exploring your Power BI model (DAX & Power Query)

License

Notifications You must be signed in to change notification settings

JaySumners/Power-BI-Tools

Repository files navigation

Power BI Tools

Overview

This repository is a store of tools-in-development, primarily in R or Python, for documenting or improving Microsoft Power BI models (e.g. scripts to find unused objects in your model).

Note: These scripts will only work on Windows

Installation

In general, you can download the script and run it in your favorite IDE or from the command line. Each tool will have specific instructions with any special requirements.

Scripts are available in folders for each tool.

Usage

Current Tools

These tools are currently in the repository and available for use.

Tools Purpose Languages (Version)
Report Download Utlity CLI & WinForms GUI to download Power BI reports on the Service as a PDF or PPTX Windows PowerShell ('5.1')
Unused DAX Objects Returns objects in you loaded Power BI model that are not necessary to any visualized calculation R(3.6.1), Python(3.7.4)
Convert Excel to CSV Converts the selected sheet of an Excel file to a CSV in the same directory PowerShell(3.0)

Future Tools

  • DAX dependencies network graph (R/Python)
  • DAX calculation flowchart (R/Python)
  • DAX object definitions (R/Python)
  • DAX coding/performance flags (R/Python)
  • Power Query query dependencies network graph (R/Python)
  • Power Query query flowchart with transformations (R/Python)
  • Power Query Get Sources to list source files (R/Python)
  • Power Query coding/performance flags (R/Python)
  • Model memory consumption with improvements (R/Power BI)
  • Shiny App and/or Power BI pbix to visualize this data in one place

About

Tools for auto-documenting and exploring your Power BI model (DAX & Power Query)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published