PowerBI Project
AHMED RAZA
Like this project
Posted Dec 23, 2024
Developed a comprehensive PHP-based solution to integrate with Microsoft Graph REST APIs for seamless Power BI report export and data extraction.
Likes
0
Views
1
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:
Part 1:
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.
Part 2:
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.