Authentication type oauth2 missing for Report Server Schedule Refresh

[Molik]

Dear all, I would like to know, what is necessary to do on a Report Server side configuration in order to support oauth2 authentication type for (data source) Scheduled refresh.

I am able to take PBI Desktop and use OneDrive / SharePoint online list or library like a source, I am able to refresh them manually or upload such a report to Report Server, however I am not able to configure Scheduled refresh for them (for any O365/M365 data source). There is simply no choice in the menu to use e-mail format of the credentials. Just Anonymous, Basic & Windows type credentials and none of this works. I also tried to use Web type connection with no luck, I tried to connect OneDrive folder like a network drive and use web type / excel type connection and again, with no luck. 

Thank you for any hint, tip or help

[d_gosbell · Accepted solution]

Unfortunately there is nothing you can do. The data sources you are asking about are officially listed as not being supported for scheduled refresh (see https://docs.microsoft.com/en-us/power-bi/report-server/data-sources ) 

You don't have a lot of good options here, but in a nutshell the main onese are to either:

• Open and refresh the reports manually using Power BI Desktop
• publish the reports on powerbi.com (which does support OAuth2 authentication) instead of on Report Server 
• build some sort of data load scripts which will pull the data from OneDrive/Sharepoint and load them into a supported on-prem data store (like a file share or SQL database) and then build your reports on the local copies of that data