Forum Discussion

Utkarsh1919's avatar
Utkarsh1919
Copper Contributor
May 08, 2024

Microsoft Project-PowerBI Integration

Good Day, There is a need wherein we want to Visualize Microsoft Projects data on PowerBI Platform as KPI's. It is possible to integrate both these platforms but is it possible to visualize or bring...
Paul_Mather's avatar
Paul_Mather
MVP
May 08, 2024

Hello Utkarsh1919 ,

Please can you advise if you are using Microsoft Project Desktop app standalone without Project Online etc.? If this is the case, Power BI can not directly access the data stored in mpp files. 

Paul

Utkarsh1919's avatar
Utkarsh1919
Copper Contributor
May 08, 2024

Paul_Mather  thanks a lot for helping out. We will be using Microsoft Project Desktop app as we have to add custom columns which will be around 40-50 nos. and this custom column data we want it on PowerBI

  • Paul_Mather's avatar
    Paul_Mather
    MVP
    May 08, 2024

    Hello Utkarsh1919 ,

    As you are using the standalone Microsoft Project desktop app that just saves data to mpp files, you'd need to find / build a solution that pushed the data from the Microsoft Project Desktop client into a central data storage that Power BI can access such as Azure SQL DBs, Data verse, SharePoint lists etc. Or look to use Microsoft Project Online, you can then use the Project Online reporting APIs in Power BI to get the data out for reports.

    Paul

Resources