Forum Discussion
Power BI and MS Project for Web data source connectivity fails
Hello Everyone,
I've installed "Microsoft Project Web App" Power BI app in Power BI service (cloud app). Link for the same is: https://appsource.microsoft.com/en-us/product/power-bi/pbi_msprojectonline.pbi-microsoftprojectwebapp?tab=Overview
There are no issues with this Power BI app installation but, when I try to connect it with the PWA (OData) data source I get an error message. Following are the error messages received:
1. "The column 'CostType' of the table wasn't found"
2. "The column 'ProjectDepartments' of the table wasn't found"
Does anyone knows how to solve this issue?
Thanks & Regards,
Rohan
2 Replies
Hello rohanw24 ,
Those fields referenced are default Project Online PWA fields, maybe you have deleted these from PWA? You will need to edit the Power BI report - click Transform Data to open up the Power Query editor, access the data sets, click an earlier Applied Step until the data loads in Power Query editor, then work out what step causes the issue.
Paul
Hi Paul_Mather,
I've not deleted any PWA fields and using as it is. I'm following steps mentioned here:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-to-project-onlinePlease note this documentation is quiet old, so there are some changes in the process.
Thanks & Regards,
Rohan
