How to change excel data source in Existing Power bi report?

[Anonymous]

Hello,
I am new to Power BI and I am not able to change data source in my PBI report.

Can you please help me with this?

[mdaatifraza5556]

Hi @Anonymous 

Please follow the steps

1. Go to file (Upper left corner)

2. Options and settings (bottom left)

3. Data source settings

After clicking on Data source settings you will see the below prompt and you can change the data source which you want.

If this answers your questions, kindly accept it as a solution and give kudos.

[Anonymous]

Thank you @HarishKM @MFelix. Your solution is working as expected.

Thanks

[AnkitaaMishra]

Hi @Anonymous , 
You can change the data source by going into transform data option :
Once the Power query window is open, click on your excel table and from Applied steps ---> click on source --->
Now you can change the path for your excel data source.

Thanks,

Ankita

[MFelix]

Hi @Anonymous ,

For that you need to go to the data source settings:

Then select the file and change source

[HarishKM · Accepted solution]

@Anonymous  Hey,
You can update your data source from your Power bi desktop. Kindly follow below step.

Select Transform data drop 
data source setting 
select data file and change data source 
update your excel reference.

Thanks
Harish.