topic Authentication type oauth2 missing for Report Server Schedule Refresh in Report Server

Authentication type oauth2 missing for Report Server Schedule Refresh

Molik — Thu, 17 Feb 2022 14:33:48 GMT

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

Re: Authentication type oauth2 missing for Report Server Schedule Refresh

d_gosbell — Thu, 17 Feb 2022 22:03:07 GMT

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