Forum Discussion

Icon for Post Patron rank

Post Patron

3 years ago

Error in file(filename, "r", encoding = encoding) : cannot open the connection Calls: source -> file

Hello, I am trying to import an R script into power BI, I tested the script in R and it works perfectly fine but when I try to import it to power bi using "get data -> r script", this is the mess...

Anonymous

Not applicable

3 years ago

I'd like to suggest you double-check the current account and permission configurations to ensure if you and power bi desktop client have enough permissions to access initiation path/folder of R script.

Regards,

Xiaoxin Sheng

OPS-MLTSD
Post Patron
3 years ago
Anonymous thanks, is there a way I can check?
- Anonymous
  Not applicable
  3 years ago
  HI OPS-MLTSD,
  
  Normally you can enter the parent folder of the configured path and right click on the folder and choose 'properties'. Then you can navigate the 'security' tab to check corresponded permission setting of different users.
  
  How to Set File and Folder Permissions in Windows (online-tech-tips.com)
  
  Regards,
  
  Xiaoxin Sheng
  - OPS-MLTSD
    Post Patron
    3 years ago
    Anonymous thank you I will try this solutiona nd get back.
    
    Meanwhile, I figured out why I am getting this error message:
    We encountered an error while trying to connect. Details: "SYMSXP"
    
    It is because I have a package in my r script not supported as part of the R packages supported by Power BI: Learn which R packages are supported - Power BI | Microsoft Learn
    The package is called fpp3 - used for time series forecasting.
    
    If anyone could tell me how I can contact Power BI - R support to get the package added, that would be much appreciated

Related content