Forum Discussion
issue w/getting an excel file stored on SharePoint/OneDrive setup on a schl refresh with credentials
Because you mention OneDrive I assume you are also referring to Sharepoint Online. If this is the case then unfortunately this is not a supported data source for scheduled refresh. Search for "Sharepoint Online" in this page Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn
Your only real option is to use a supported data source. For files this probably means storing this file in a network share. Or maybe writing some script to pull the file contents into an on-prem SQL Server or something like that.
Or the other option if all the data is in Sharepoint Online is to host your pbix file in a cloud based workspace instead of using the on-prem Report Server.
Helper IISorry to be the bearer of bad news, but SharePoint Online and OneDrive for Business are not supported as data sources for data refresh for reports published on a Power BI Report Server (believe me, I really, really wish Microsoft would add support for it). They are, however, supported on Power BI Desktop and the Power BI cloud service.
To use SharePoint Online data with the report server, you will first need to extract the information from SharePoint or OneDrive and store it elsewhere like a SQL database or an Excel workbook sitting on a conventional file server. We had to do this for a client who stores their data in SharePoint but wants to publish their reports to PBIRS; we wrote almost 40 ETL tasks to pull each individual list and drop them into tables in a SQL database.