Forum Discussion

MVP

Re: Error message trying to retrieve Projects table (POL) using OData Flux in Excel / Power Query

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

5 Replies

Camila_IB
Copper Contributor
Oct 20, 2022
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
- Paul_Mather
  MVP
  Oct 20, 2022
  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
  - Camila_IB
    Copper Contributor
    Oct 21, 2022
    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

Resources