Forum Discussion
PWA ODATA Credentials
Given the fact that I do not know what information is being reported upon I can only provide a generic response.
As part of "proving the pipes" temporarily increase the refresh account PWA rights to admin and see if it works. That being proven, the refresh account would need readonly rights to the PWA sites (all of them?). If so, then the refresh account will need to be added to each site (and granted the same access in the template site so new sites have the access). A better way would be to access the PWA reporting schema in the PWA database (if the required data resides there).
Thanks. I have already granted admin rights to the PBI service account in at the top-level PWA site collection and this is how I am able to schedule the refresh of my SharePoint data. I can connect directly to my PWA SQL reporting database and setup the data refresh with the service account but I was trying to use OData so it would eventually be migratable from our PWA on-prem environment to the cloud.
Have you confirmed that PWA supports OData?