topic Re: Unable To Schedule A Refresh If One Or More Data Sources Are A File in Report Server

Unable To Schedule A Refresh If One Or More Data Sources Are A File

Pie_Dev — Thu, 23 May 2024 23:48:45 GMT

I have two data sources in a report.

File
SQL

Since I have a File data source which can not schedule a refresh, the SQL data source is now also unable to schedule a refresh.

This is a clear bug as the SQL data sources should still be allowed to use a schedule.

Re: Unable To Schedule A Refresh If One Or More Data Sources Are A File

Anonymous — Fri, 24 May 2024 05:32:16 GMT

Hi Pie_Dev ,

In addition to the above list, there are specific scenarios with data sources in import mode, for which you cannot create refresh plans.

If a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents.

All that can be done now is to either change the path of the file or delete the file data source

Below is the official link will help you:
Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Unable To Schedule A Refresh If One Or More Data Sources Are A File

Pie_Dev — Fri, 24 May 2024 07:10:47 GMT

So if I have multiple SQL data sources and one file data source. Then I can't refresh any of my data sources because of that single file data source?
That is a definitly a archeicture failure.

Re: Unable To Schedule A Refresh If One Or More Data Sources Are A File

Anonymous — Mon, 03 Jun 2024 06:14:24 GMT

Hi Pie_Dev ,

You need to change the path, which must be to a network share to which the report server can connect.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.