Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.