Forum Discussion
Error message trying to retrieve Projects table (POL) using OData Flux in Excel / Power Query
Hello, I have been using an OData flux for the past 6 months to be able to create Excel reports using the data we have in Project Online. It was working great and for some reason now it just stopped working.
I keep getting an error message (see screenshots in the next session) when trying to retrieve the "Projects" table specifically.
It is weird as all the other tables I am still able to retrieve the data from. I made sure to double check the authentication credentials and login with my proper Professional Account and it still gives me the error. I tried connecting to my company VPN and it made no difference. I have tried everything I could and can't find a solution. This is a huge blocking as most of our reporting uses data from Project Online.
Any ideas?
Please find below screenshots of the whole process and the error message:
Trying to retrieve the "Tasks" table works perfectly for example:
But the "Projects" table, which is essential for us, will keep giving me an error:
Any troubleshooting ideas would be greatly appreciated!
Thank you!
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
6 Replies
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
