Forum Discussion
Can't set scheduled refresh
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.
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.
Thank you!