Change location of local files to Gateway - Best Practices

[rnehrboss]

I have developed a local pbix file using local excel files that just reference my local C drive.. I'm not attached to a network.

I have a gateway running and working.  I can add a New DataSource to the gateway that references a mapped directory to where the files really are and will be updated.   I now want to publish my pbix and have the datasources map to to "file" datasources that I setup for the gateway.

Not really sure how to do that.   

I think I could put my pbix on a computer on the network that has access to that shared directory and then change the file location to the mapped drive, but that would be painful.. IE if I wanted to edit on my local non-network attached computer, I'd have to repeat the process and edit all sources again on a network attached computer.

Any ideas?    

[v-yalanwu-msft · Accepted solution]

Hi, @rnehrboss ;

First, the data source is a local file such as Excel; We generally use personal data gateways; The steps to refresh the data are as follows:
1. Install the personal gateway.
Use personal gateways in Power BI - Power BI | Microsoft Learn

2.The second is to publish the pbix to service in Power BI.

Publish from Power BI Desktop - Power BI | Microsoft Learn

3.setting gateway.

4. edit credentials.

Here are the whole steps to configure the gateway (for excel)
So when you want to change the location, just change the last step and modify the credentials;

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.