I have a customer that is trying to connect his On-Prem PWA. He is trying to use a refresh account that has the least amount of privlidges. Everytime he tries it fails to authenticate. What permissions should an account have in PWA to connect to PWA ODATA?
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
Log on failed. Ensure the user name and password are correct.
I am having the same issue. Using an org. account, I am connecting to my on-prem PWA data using REST API calls in Power BI Desktop. After the report is published to the PBI Report Server, I cannot find a method to refresh the data.
I can easily refresh (PWA) SharePoint list data using my PBI service account and thought I would be able to do the same thing with an OData data source. Does anyone have a solution or workaround for this? Why is this so hard?
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.