Forum Discussion

Sportynick's avatar
Sportynick
Frequent Visitor
6 years ago

Data refresh where data file is in a shared folder on network

Hi, Currently have a setup where a shared dashboard is refreshed daily, with data from a file in shared drive on company network. Problem is gateway is my personal laptop, so refresh error occurs wh...
Dataflow
venal's avatar
venal
Memorable Member
6 years ago

Sportynick 

Use the On-Premises data gateway and configure the datasource under the gateway for refresh.

 

Please refer the below links.

 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/service-gateway-data-sources

 

If you have any concerns, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

BR

venal.

 

Sportynick's avatar
Sportynick
Frequent Visitor
6 years ago

Hi Venal,

Went ahead to set up the on-premises data gateway, but received the following error:

"Unable to connect to the data source. 

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support."

Not too sure why the error occurs, setup seems fine and there is a green tick next to on-premises data gateway.

Still, would like to understand more on how this differs from personal gateway setup: status in both instances shows "Running on [my laptop serial code]".

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Sportynick ,

     

    If you have install the On-Premises Data Gateway (Standard Mode) in a machine which can access the data source, Then we can configure a data source in "Manage Gateway" and enter the credential for it. At last, We need to go to the dataset setting, and map your data source of dataset to the data source under gateway. It is different from the Personal mode which just need to configure credential under the dataset setting:

     


    Best regards,

     

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Sportynick ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

    • Sportynick's avatar
      Sportynick
      Frequent Visitor
      6 years ago

      Hi Dong Li,

      Thanks for following up and i understand your guidance as setting up the gateway to link to the server. Currently mine shows the file path on the shared drive only and so does not work. Seems that to do what you have guided, i would need to work with the IT admin to set it up, as need info on the server the shared drive is hosted on etc.. Perhaps as an alternative i should upload the data to SharePoint and then refresh from there, so that it will work for sure.