Forum Discussion
Project Server Power BI Content Pack - Connect to Billed Work Hours?
Is there a way to use the templates in the Project Server Power BI Content Pack and connect to an excel spreadsheet containing the hours billed/charged to a project?
Since MS Project simply calculates Actual Work based on % complete status update, we want to compare the "Actual" hours billed to a project to the Remaining Work to get a better picture of whether labor hours are on track to be over/under budgeted hours. ("Actual" hours from an export from our accounting system + "Remaining Work" from the MS Project schedule = Estimated Work at Completion; compare this to Baseline Work).
Has anyone done something like this in your organization, and if so, how did you connect these 2 sets of data and create a visual for people in your organization?
1 Reply
This can be done. In the PS PBI Content pack you add the Accounting data to your data model, establish your relationships then build your reports and measures as needed.
