Introduction and First Run
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.
When the report is launched for the first time the privacy level dialog comes up. Select the file drive and the database to have the same privacy level, e.g. Organizational
- Issue: Opening the report results in the error message "Connecting to tables from more than one database isn't supported in DirectQuery mode" appearing.
Resolution: PowerBI versions released after November 2017 appear to have an outstanding issue with opening reports in DirectQuery mode, until this issue has been resolved the solution is to install the November release.