Write/ Append a data frame to a file on Shared drive using Power BI

[rishi_hemwani]

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.

[v-jayw-msft]

Hi @rishi_hemwani ,

Do we have an on-premised data gateway for this datasource?

Best Regards,

Jay

[rishi_hemwani]

Yes, I have organization's on-premise data gateway.

Thank you for your response.