Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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
@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