Forum Discussion
Error message trying to retrieve Projects table (POL) using OData Flux in Excel / Power Query
Hello Paul_Mather ,
After much googling I was finally able to resolve the issue.
At the beginning of this week my team and I did a clean up of the custom project fields that we use in Project Online. Turns out that there are certain specific words that can cause issues with the OData flux, such as "Project", "Category" etc...
Basically you have to be careful when naming the custom fields, as some words are reserved in some way:This was the post I found that was helpful: https://techcommunity.microsoft.com/t5/project-support-blog/project-online-using-reserved-custom-field-names-breaks-odata/ba-p/361488
I should have realised it was something to do with the fields as the issue appeared a day after we did that clean up in Project Online.
Really appreciate your help with this! Hopefully this can be useful for other people running into the same issue in the future.
Have a great day.
Best,
Camila
Hello Camila_IB ,
Can you try the following:
- Access PWA in the browser
- Then update the URL in the browser URL bar to:
- https://{tenantName}.sharepoint.com/sites/construction-pwa/_api/ProjectData/Projects
- Replace tenantName with your tenant
- Press enter to access that URL above
- Do you see the project data load here in the browser or does it give an error?
Paul
Hello Paul_Mather ,
Unfortunately it is not loading any data when entering that new URL. Here is what I get:
However, I can see my project list without any issues when accessing the following URL:
https://({tenantName}.sharepoint.com/sites/construction-pwa/Projects.aspx
Any ideas?
Appreciate the help!
Thank you!
Best,
Camila
Hi Camila_IB ,
I've just noticed the site in not in English, try this:
https://{tenantName}.sharepoint.com/sites/construction-pwa/_api/ProjectData/Projets
Paul
Hi Paul_Mather ,
I actually tried that yesterday as well. I thought it could be that, but it gives me the same result:
Thanks,
Camila