Can't set scheduled refresh

[Anonymous]

Hi there,

My report mainly contains data derived from SQL, with one set of data coming from Excel. I've disabled the load and refresh options for the Excel table:

However, when I try to set up the scheduled refresh on the report server, it doesn't allow me to:

How can I overcome this issue please?

Thanks.

[d_gosbell · Accepted solution]

Unfortunately the scheduler cannot see into your data model to see if the data sources are used or not.

Since it looks like you are already using a network drive for this one fix would be to configure this connection to use a UNC path instead of the drive mapping (this is because the M: drive is specific to your user and does not exist on the server). If you open Windows Explorer you should see some other text infront of the M: drive. It will be in the form of "<share_name> ( \\<server_name>) (m:)"

so instread of referencing the file as: m:\administration\f&c\...

you should be able to use: \\<server_name>\<share_name>\administration\f&c\....

If you change this in Power BI Desktop then re-upload the file to the Report Server you should then be able to store credentials against all you data sources and then you can configure a scheduled refresh. You should even be able to enable the Excel file for refresh if you wanted to.

[Anonymous]

Thank you!