Refresh error of [Model can not be refreshed for files not mapped to a network share]

[Dearc]

Hi Microsoft Power BI Report Server Team:

After updating RS to version 1.12.7936.39665(September 2021) . Strange refresh error happened as log show below

2021-11-15 01:30:14.6218|ERROR|257|Model can not be refreshed for files not mapped to a network shareMicrosoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
2021-11-15 01:30:14.6218|ERROR|257|Error Processing Data Model Refresh: SessionId: 057e4f92-1d50-4a3c-8da6-11943cc72aaa, Status: Error Model can not be refreshed because not all connection string is valid, Exception
Microsoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.ValidateConnectionString(IEnumerable`1 dataSources)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2021-11-15 01:30:14.6218|ERROR|257|Error Processing Data Model Refresh: SessionId: 057e4f92-1d50-4a3c-8da6-11943cc72aaa, Status: Error Failed Data Refresh, Exception Microsoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteStep[T](Action`1 methodToExecute, T arguments, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, Boolean sendToTelemetry)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()

I don't know why "not all connection string is valid" because the data source tested OK and no any problem when refresh in desktop version.

I have 3 report server deploy as scale-out.

Can you help to check how to fix it? @Petebro 

[Dearc · Accepted solution]

After upgrade all scale-out report server to same version, and re-orgnized the scale out, problem solved

[Dearc]

Hi @v-henryk-mstf 

I set the refresh plan this day show as below

And I checked the log files the latest one after sevral hours

 searching by the session id, but got nothing

datasouce link tested OK.

[Dearc]

Please dont this down, we're still suffer on this.

[v-henryk-mstf]

Hi @Dearc ,

I apologize for the untimely response, I am unable to reproduce such error scenarios at this time. I suggest you create a support ticket through the following blog and an engineer will follow up to help you resolve the issue.

How to create a support ticket in Power BI - Microsoft Power BI Community

Looking forward to your feedback.

Best Regards,
Henry

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

[Dearc]

Thank you and I send out the ticket now. This problem still happen

No error log in log files[2021-11-30 9:10 is missing, the 9:15 is successed], so I think the refresh may not happened due to interupation by some check steps.

[v-henryk-mstf]

Hi @Dearc ,

Normally, regardless of the success or failure of the refresh, there will be a record of SessionId related information in the RSPowerBI_*.log file. Can you further describe the data source information you configured?

Troubleshoot

Looking forward to your feedback.

Best Regards,
Henry

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

[Dearc]

I think report server missing some error log, I checked log

SessionID: e105ac1e-beac-4fd4-8c59-57acf3644376
[0] -1055784932: Credentials are required to connect to the SQL source. (Source at ..). The exception was raised by the IDbCommand interface.

but also found nothing when checking the session id or failure keywords. 

But refresh can be success mannually triggered.

So I guess some schedule plan did not happened because somehow it is failed of data source(eg. Link validation, .Credentials validation....) verify process eariler.

[Dearc]

Strange found that 

Model can not be refreshed for files not mapped to a network share

this error not even not records in RSPowerBI log when I searching the sessionID.

[Dearc]

I saw this error in report server

Model can not be refreshed for files not mapped to a network share

but error log shows

|ERROR|149|Error Processing Data Model Refresh: SessionId: c07a1b1d-60f7-46ab-89d2-21784e81aa8d, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The credentials provided for the File source are invalid.

but data source tested OK. Mannually refresh is OK.

[Dearc]

2021-11-22 01:30:09.2673|ERROR|84|Model can not be refreshed for files not mapped to a network shareMicrosoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
2021-11-22 01:30:09.2673|ERROR|84|Error Processing Data Model Refresh: SessionId: 5ed820c5-571e-440e-8486-52f8502e7fd6, Status: Error Model can not be refreshed because not all connection string is valid, Exception Microsoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.ValidateConnectionString(IEnumerable`1 dataSources)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2021-11-22 01:30:09.2673|ERROR|84|Error Processing Data Model Refresh: SessionId: 5ed820c5-571e-440e-8486-52f8502e7fd6, Status: Error Failed Data Refresh, Exception Microsoft.PowerBI.ReportServer.AsServer.InvalidDataSourceException: Model can not be refreshed for files not mapped to a network share
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteStep[T](Action`1 methodToExecute, T arguments, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, Boolean sendToTelemetry)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()

I have to enabled verbose logging and hope found more.

[Dearc]

I have upgrade server to version 1.12.7977.29537(September 2021) problem still existed.

I have to trigger refresh mannually.

[d_gosbell]

This error: 

Model can not be refreshed for files not mapped to a network share

would imply that you possible have connection strings to files using a drive reference (eg  g:\myfolder\myfile.csv ) If you have any file references like this they will usually work fine on Power BI desktop but fail to refresh on the server. This is because drive mappings are relative to the user and the service account running report server may or may not have the same drive letters available. The best approach here is to use a UNC path (eg \\servername\sharename\myfolder\myfile.csv )

If all your file references are already using UNC paths you should raise a support ticket with Microsoft so that an engineer can investigate this further.

[Dearc]

Thank you for reply, I have already using UNC paths and when I trigger refresh mannully it can be success.

But runing in service, it has high probably failed as the upper error log shows.