PowerBI Model Report

Setting Up the PowerBI Report

Step one: Download PowerBI Desktop

The CRQ PowerBI model report is a Microsoft PowerBI Template File (.pbit). To open the file you will need the free Microsoft PowerBI Desktop App.

Step two: Copy the full filepath to the Excel Model File

Make sure to fill out the Excel Model file before setting up the model report. Once setup, you can update the Excel model file and refresh the report to update it.

Step three: Open the Model Report Template File

Double click on the PowerBI Model Report Template File (.pbit) to open it in Microsoft PowerBI

Step four: Paste the full filepath to the Excel Model File

Make sure to remove any quotation marks (") from the beginning and end of the filepath

Step five: Save your file as a PowerBI file (.pbix)

That's it!