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

[Sportynick]

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 whenever my computer is turned off at refresh time (e.g. i'm out of office).

However i also have a power automate setup that runs even when my computer is turned off.

Is there a way i could set up the gateway for Power BI such that the refresh occurs even when my laptop is turned off, similar to how the power automate flow works? Believe this is possible considering the company's server is still running.

[venal]

@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]

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]

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]

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.

[v-lid-msft]

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,

[Anonymous]

If the gateway is on your computer and your computer is off, then it cannot run because your computer is what does the work.

Gateways are best installed into a server that can stay on 24/7