Help connecting to a custom list within Project Workspaces in Project Web Application

[Anonymous]

I need help figuring out how to connect to a custom list within each project workspace in my organization's Project Web App using PBI Desktop. I can connect to more general project data via OData feed, but I can't find the custom list I need within that data.

Just in case this is somehow related to the issue I'm having - I've also tried to connect to an individual custom list associated with a particular project via Sharepoint List/Online List and Sharepoint Folder (ex. URL: https://<tenant name>.sharepoint.com/sites/pwa/<project name>/Lists/<Custom List name>) But, I receive the following error in each case - 

Any ideas/guidance for how to connect to a custom list within a Project Workspace in Project Web App would be greatly appreciated!

[muneebch041]

I have the solution, You can connect with me.

It will be done in combination of O data and Web.

For the solution email at: muneebch041@gmail.com

[v-yuezhe-msft · Accepted solution]

@Anonymous,

The Project Data ODATA feed only contains the default Project Site lists and default columns (Risks, Issues, etc.), custom lists and columns are not included.

To connect to custom list within Project web application, please check the sample code in the blog and similar thread below.

https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-projectonline-projectserver-powerbi-powerquery-bi-office365-excel-ppm/

https://community.powerbi.com/t5/Issues/HTML-formatting-for-Project-Online-Power-BI-Reports/idc-p/343131#M20966

Regards,
Lydia