Forum Discussion

rishi_hemwani's avatar
rishi_hemwani
Frequent Visitor
6 years ago

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

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.

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rishi_hemwani ,

     

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

     

    Best Regards,

    Jay

    • rishi_hemwani's avatar
      rishi_hemwani
      Frequent Visitor

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

       

      Thank you for your response.