Forum Discussion
How to connect mpp file to Power Bi
Hi,
I have a MPP file and is changing with daily frequency,
I want to import it to power bi but I did not find a solution,
I would greatly appreciate any help. Thank you
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.
3 Replies
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.
Hi, are you talking about an MS Project file?
Hi @Syauqi,
I don't think there is. Not with the desktop version of Microsoft Project that is. If you move to Project Online, it can be done quite easily as described here: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
