Introduction

Power BI Reports harnesses the power of Microsoft Power BI and the wealth of information stored in the Migration Accelerator staging database to provide intuitive and interactive drill down reports.

To view the reports for a task, select the “Power BI Report” from the ‘Select a Report’ dropdown. Select the task for which the reports need to be generated, and click ‘Run’. This will launch Power BI with information related to that particular task. To view a complete report for the entire source system, run this report on a task that has the source mapped at the top level.

Power BI Desktop Install

A pre requisite for this report is the installation of Microsoft Power BI Desktop. Install Microsoft Power BI Desktop from the Microsoft site site https://powerbi.microsoft.com/en-us/desktop

Install the product in its default location. If the product is installed in a custom location, please contact Proventeq support for help with configuring the Migration Accelerator for custom path.

Set up PBI Environment

The installation of Proventeq Migration Accelerator creates a directory called Proventeq in directory (typically C:\Proventeq\PowerBI ) and its containing the .pbix and .CSV file

1. On clicking the Power BI report from the Migration Task. Open the file by clicking ok to trust the sender.

2. Click Validate to continue with respective credentials.

3. Select the file drive and the database to have the same privacy level, e.g.
Organizational