PowerBI Project

Developed a comprehensive PHP-based solution to integrate with Microsoft Graph REST APIs for seamless Power BI report export and data extraction. The project is divided into two parts:

Created a PHP script to request and export Power BI reports using the exportToFile API.

Utilized CURL to handle authentication and API requests, ensuring secure and efficient communication with Microsoft Graph.

Implemented polling logic to check the export status and download the report as a PNG or other image format once ready.

Automated the storage of exported reports into a designated server folder for streamlined access and management.

Developed a PHP script to export Power BI report data sources and save them into a MySQL database.

Provided an option to save the extracted data as a CSV file for easy external use.

Enabled dynamic report data fetching by passing the ReportID as an input, ensuring flexibility for different report exports.