SharePoint Custom Columns and OData feed

Hi Paul,

Adding new custom columns to the default Issues and Risks lists and adding new lists to the project sites is very simple as you have mentioned, reporting is a bit more involved if you wanted to create a portfolio issues reports and include those new columns etc. The default Project Online OData Reporting API (_api/ProjectData) only includes the default Issues and Risks columns, so custom columns will not be available here for reporting. For an out of the box approach, you would need to use the SharePoint List REST APIs to get this data in Power BI. See an example here: https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-projectonline-projectserver-powerbi-powerquery-bi-office365-excel-ppm/ Please note, this will only refresh in the Power Bi Desktop client, the data will not refresh in the Power BI app service (well it didn't the last time I looked at this!). Another approach is to look at extracting the data out into a SQL Database for example, them the Power BI report just queries the SQL database. You can either build something yourself or there are many third party products that do this.

Paul