Fatal error: cannot create 'R_TempDir'

[KislayT]

Hi All,

I am trying to run R scripts using Power BI but getting below error.

Any idea to fix the issue would be highly appreciated.

Thanks.

Error details below:

----------------------------------------------------------------

Client Error Code:
ServiceErrorToClientError

Error Details:
R script error.
Fatal error: cannot create 'R_TempDir'



Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Fatal error: cannot create 'R_TempDir'

 ---> Microsoft.PowerBI.Radio.RScriptRuntimeException: R script error.
Fatal error: cannot create 'R_TempDir'


   at Microsoft.PowerBI.Radio.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
   at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
   --- End of inner exception stack trace ---
   at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
   at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, String dataShapeId, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteDataQuery(IQueryResultDataWriter queryResultDataWriter, DataShapeGenerationContext dsqGenContext, EntityDataModel model, DataQuery query, ServiceErrorStatusCode& serviceErrorStatusCode)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)

[v-qiuyu-msft]

Hi @KislayT,

I didn't know how did you execute the R script then error throws out. To run R script, you can follow those two articles:

Running R Scripts in Power BI Desktop

Using R in Query Editor

Best Regards,
Qiuyun Yu

[KislayT]

Hi,

I am now user of Power BI, and I have started exploring R integration with Power BI.

I am trying to run R scripts using Power BI but unable to execute, same script runs fine with R Studio; it seems Power BI is unable to create Temp directory.

I provided full permission to the temp directory as well as R Home directory to the user "Everyone", butstill didn't work.

(I know this is not a good idea, but I was trying to find if some permission issue is there somewhere 🙂 )

Any idea to fix the issue would be highly appreciated.

Thanks.

Error details below:

----------------------------------------------------------------

Client Error Code:
ServiceErrorToClientError

Error Details:
R script error.
Fatal error: cannot create 'R_TempDir'



Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Fatal error: cannot create 'R_TempDir'

 ---> Microsoft.PowerBI.Radio.RScriptRuntimeException: R script error.
Fatal error: cannot create 'R_TempDir'


   at Microsoft.PowerBI.Radio.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
   at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
   --- End of inner exception stack trace ---
   at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
   at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, String dataShapeId, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteDataQuery(IQueryResultDataWriter queryResultDataWriter, DataShapeGenerationContext dsqGenContext, EntityDataModel model, DataQuery query, ServiceErrorStatusCode& serviceErrorStatusCode)
   at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)