Import New Excel File in replace of Current Dataset

[lardo5150]

So, I have craeted a new Dataset from an excel file that I export from a program.

I was testing this, but it all went so well.

I did some data transform and such.  Created measures, etc. etc.

I just realized that I was doing this as a test, but now i want to keep all of this and actually pull the data from a one drive or something.

Right now, I am using an Excel file exported from a program that was saved with NAME1 to my local drive.

I actually want to make this official, and pull the data from an excel file that I will manually export, from the same program, with NAME2, from one drive or some other place.

Is it possible, to just replace the data in my Power BI without losing all my stuff?

[amitchandak · Accepted solution]

Go to Transform Data under the home tab, click and choose a Data Source setting. Change the file path. As long as the data structure is the same it will work(rows can increase ).