Power BI and MS Project for Web data source connectivity fails

[rohanw24]

Hello Everyone,

I've installed "Microsoft Project Web App" Power BI app in Power BI service (cloud app). Link for the same is: MS Project for Web App 

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]

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

[#3]

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-online 

Please note this documentation is quiet old, so there are some changes in the process.

Thanks & Regards,

Rohan