I've built a report that pulls data from multiple sources, one of which is a Sharepoint list (which is a new experience for me). In Desktop, everything works fine. I use my organizational account to access the data, and everything works wonderfully. I can refresh the data, and everything works.
Once it has been pushed to the service, the report is fine. However, refreshing from the service, while it "succeeds" (i.e. there are no error messages), all data from the Sharepoint list is stripped out -- nothing shows up in the visualizations that use that data source. It's as if the refresh process found the Sharepoint list, but was unable to retrieve any data.
When I go to the scheduled refresh page and click on Data Source Credentials, there is *always* initially the following error message: "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." Out of my 5 data sources in this report, the only one that gets the little spinny wheel is the Sharepoint list. After a moment or two, the spinny wheel stops, the error message disappears, and I can schedule a refresh. BUT, if I click on "Edit Credentials" next to the Sharepoint list data source, it *always* comes up as "Anonymous" by default. (Note that when I added this data source in Desktop, I did not access it anonymously. I've checked in Desktop, and it is still set to use my organizational credentials to access the list. It actually fails to access the list [permission denied] if I try to access it anonymously.) If I change it from "Anonymous" to "OAuth2," that process seems to work, but if click again on "Edit Credentials," the "Anonymous" option is re-selected. Refreshing from the service after I go through this process results in the loss of the Sharepoint list data in the report.
If I refresh in Desktop and re-publish to the service, everything is fine.
I'm refreshing through a "personal mode" data gateway.
Please help!
Update: Apparently, the data in the list will show up in a report in the service *so long as scheduled refresh is disabled.* If scheduled refresh is enabled, the list data shows up for a handful of minutes after publishing from desktop, but then it simply vanishes. I don't have to take any action for this to occur. I'm not even refreshing from the service. The data just disappears. Again, if scheduled refresh is disabled, the list data will stay in place....that is, until I refresh from the service. This is very bizarre behavior.
