Updating Data with a Flat File (.csv) / Direct "Refresh" to another location

[irnm8dn]

As an interim solution I am using a flat file, which daily needs to be uploaded to update the data in Power BI.

When using the Refresh button on the ribbon, it successfully uploads the new file from my desktop.  Is it possible to change the location where Power BI looks for the file, so it pointed "Away" from the desktop.

I am not at a point that I am ready to fully automate the solution.

Thanks.

[blopez11 · Accepted solution]

You can do so in the query editor

From the Home tab, select Edit Queries

Select the query in question from the Query area on the left

Select the gear icon, next to the Source step on the right

You can then change the path from the pop up

Hope this answers whta you were wanting to do

[Anonymous · Accepted solution]

Hi irnm8dn

In Power BI Desktop you can change the source file in an easy way.

Choose "Edit Query" and change your source.

Greetings

Hp Pfister

[blopez11 · Accepted solution]

You can do so in the query editor

From the Home tab, select Edit Queries

Select the query in question from the Query area on the left

Select the gear icon, next to the Source step on the right

You can then change the path from the pop up

Hope this answers whta you were wanting to do