Hi Everyone:
I am trying to write back the results from a selected measure in a csv / excel file stored in shared drive using Power BI.
To ellaborate:
I have a R visual in Power BI where in the R script gets input parameters from the slicer.
These input parameters are variables to my forecast model written in R script.
The result from the model needs to be stored in the csv / excel file (storing the results in SQL server will also work)
The csv / excel file is sitting in a company shared folder.
Everything works fine, when I try to run the pbix on local machine. The main problem starts when I publish the Power BI service.
The Power BI service throws the error:
cannot open file '\\server_name\folder_name\file_name.csv': No such file or directory
Please help me if there is anything wrong in the process or if there is any work around.
Thank you.
