How do I connect Power BI Desktop to Microsoft Project as data source?

[Anonymous]

I have this requirement which requires me to use Microsoft Project as my data source in Power BI. Is it possible? If so, how? I have read some articles regarding the use of a Web App to connect to Project Online but can it be done using direct connection from Project to Power BI?

[amitchandak]

Hope you already referred these

https://docs.microsoft.com/en-us/power-bi/service-connect-to-project-online
https://docs.microsoft.com/en-us/power-bi/desktop-project-online-connect-to-data
https://www.analytics8.com/insights/how-to-get-data-from-ms-proj-into-your-bi-tool/

[Anonymous]

Hi,

Thanks for your input. However, I'm actually looking for a connection from Microsoft Project (Desktop/MPP Files/Not MP Online) to Power BI. So far, I've seen third-party connectors such as CData's ODBC Driver for Project and Microsoft Project to Power BI connector. Are there any alternative options for free? Or any work-arounds.

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @Anonymous ,

It is not supported to connect Microsoft Project into Power BI Desktop directly. Maybe you could try to export the mpp files to Excel sheets with mpp viewer and then import them into Power BI.

There is an idea that you could vote up to get the feature fixed quickly.

Add a connector for MS Project MPP files 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.