Cannot access Project data table through Power Query / Power BI

[joemillson]

Hello,

I am currently able to access data in power bi / power query via OAuth:

https://XXXXXX.sharepoint.com/sites/pwa/_api/ProjectData

When I do this, it shows me all the available tables I can load. For example, I load 'TimesheetLines', and it loads the table. I have to sign in prior using my Organisation credentials, and this works fine.

(I have full admin right on my organisation's O365 account, with Project, and Power BI licenses)

However, when I try to load the 'Projects' table, it asks me again for credentials but then gives me an error 'The user was not authorized'.

Can anybody help? It's a big issue for us at the moment

Many thanks

Joe

[Anonymous]

Make sure you have access to view the project data, i.e. you are in Portfolio read group or any other user group that can read the project data.