Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Anonymous  thanks, is there a way I can check?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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