Following on from my previous blog post regarding the updated Project Online Power BI content pack from Microsoft – see below if you missed it:
That was shortly removed from the Power BI service and hasn’t been updated there yet but the template file has since been made available to download from GitHub:
You can now have the default reports provided here and extend to your own requirements for example a quick change would be to change the currency symbol used if you are not using US dollars:
Another change you might want to do, is make this report pack support non-English PWA site collections. This can be done by editing all of the queries in the Query Editor, use the Advanced Editor and update the code: OData.Feed(#”PWA Site URL” & “/_api/ProjectData”), to OData.Feed(#”PWA Site URL” & “/_api/ProjectData/[en-US]“), This will ensure all of the properties exist and the reports work.
Make the changes as required then publish to your own organisation.