Forum Discussion
How to connect mpp file to Power Bi
Power BI can’t connect directly to a local .MPP file, but you have two reliable options:
Project Online (recommended):
If you can,move your project to Project Online , connect using the OData feed:
https://<tenant>.sharepoint.com/sites/<PWA>/_api/ProjectData
This method is fully supported and allows automatic refresh in Power BI Service.2. Power Automate Desktop:
If you only have a local .MPP file and moving to Project online is not an option, create a desktop flow that opens the file in Microsoft Project, exports it daily to Excel or CSV, and saves it to OneDrive or SharePoint. Then connect Power BI to that exported file for scheduled refresh.Project Online is the cleanest solution.
Power Automate Desktop is a working workaround for local files.Shai Karmani | Data & Analytics
If it helped ✅ please mark as resolved & give a kudo so others can find it too.
Super UserPower BI can’t connect directly to a local .MPP file, but you have two reliable options:
Project Online (recommended):
If you can,move your project to Project Online , connect using the OData feed:
https://<tenant>.sharepoint.com/sites/<PWA>/_api/ProjectData
This method is fully supported and allows automatic refresh in Power BI Service.
2. Power Automate Desktop:
If you only have a local .MPP file and moving to Project online is not an option, create a desktop flow that opens the file in Microsoft Project, exports it daily to Excel or CSV, and saves it to OneDrive or SharePoint. Then connect Power BI to that exported file for scheduled refresh.
Project Online is the cleanest solution.
Power Automate Desktop is a working workaround for local files.
Shai Karmani | Data & Analytics
If it helped ✅ please mark as resolved & give a kudo so others can find it too.