The Reports migrations from SAP BO to PowerBI, having optimizing the SQL code (datasets) according to PowerBI standards. Make sure the SQL Queries developed are not performance impacted. Adding complex report expressions at query level. Helping the PowerBI Report Developers with the issues they come across during report development. The Power BI reports via Energy Components (EC) gets generated with all the features required by the help of Power BI reporting API call. Power BI API connects EC with Power BI App Workspace service where Power BI reports are published) and makes Power BI Report Generation via EC easier. •Considering end of life for SAP BI, reports are migrated and developed using Power BI Paginated Reporting builder tool (SAAS based) for most of the EC OU’s. • This API uses OAuth 2.0 authorization protocol and few code changes are integrated with JAVA. This API automation supports both multiple page as well as single page/tab download in EC. Aarthi Chandrasekharan, Sidharth, Muthu have been working on with the Migration for NAMEC,WGT,PRELUDE