HomeItemPower BI Report Template

Power BI Report Template

Need to have a consistent template for your Power BI environment?  Need to provide a cover page with report information, business and technical contacts, and a changelog? Want to auto-document your data model, table/column/measure descriptions, and measure expressions? Also want to capture end user feedback on the Power BI solution from your end users? Providing your development team with a head start on a Power BI solution saves hours, makes your team more efficient, and provides a cohesive look and feel across all solutions.

Import your own JSON business theme, logos, and layouts to even further customize your template.

This solution will be updated periodically as new feature requests and other thoughts on what could be added to improve the solution. Make sure you’re running the latest version. The report will have a version displayed and notify you if there is a new version available.

Features

  1. Parameter driven data collection to capture and display
    1. Report name
    2. Department
    3. Description of report
    4. Last refresh timestamp
    5. Refresh frequency (to display to the audience)
    6. Business owner and contact information
    7. Business support information and contact information
    8. Technical support information and contact information
    9. Changelog information
  2. Dynamic calendar created in Power Query
    Uses parameters to dynamically calculate the start and end date to use for your calendar

    1. years to keep
    2. start date option to keep last n number of years based on today’s date or first of year
    3. end date option to use today’s date, end of year date, end of next year date, +1 year, +2 years
    4. week start day (Monday – Sunday)
  3. Self-referencing data definitions from the model once published (optional)
  4. PowerApps report survey (optional)

Instructions

If you purchase the version with the PowerApps survey included, you will also get a file that includes the PowerApps export. In order to install the PowerApps solution and reconnect the Power BI solution to your newly imported PowerApps solution, you will need to follow the following steps:

  1. Import the PowerApps solution into your PowerApps environment following the directions to import a PowerApps solution from here: https://powerapps.microsoft.com/en-us/blog/powerapps-packaging/
  2. Remove the PowerApps visual from the report template “Cover” tab.
  3. Add the PowerApps visual back to the report template “Cover” tab.
  4. Add the [ReportName] measure from the ‘_Cover’ table to the PowerApps visual in the PowerApps data section.
  5. Inside the PowerApps visual, follow the instructions to point to your newly imported PowerApps solution in your PowerApps environment.

Demo

  • Power BI Report Template w/ self-referencing data dictionary and PowerApps Report Survey

    Billed $20 yearly until cancelled

  • Power BI Report Template w/ self-referencing data dictionary

    Billed $12 yearly until cancelled

  • Power BI Report Template w/ cover page parameterized data

    Billed $6 yearly until cancelled

Purchase

You must log in and be a buyer of this item to submit a review.

Download Custom Category , ,
By Source Power BI XMLA
By Application Power BI
By Language
By: PowerDAX
PowerDAX
Author Since: Dec 2019 Vendor Page →