How to connect mpp file to Power Bi

[Syauqi]

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

[tayloramy]

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.

[Shai_Karmani · Accepted solution]

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.

Let’s connect on LinkedIn

[Hans-Georg_Puls]

Hi, are you talking about an MS Project file?