Forum Discussion
Applied Steps
How did you upload the Excel file?
The normal way is to use "Get Data" and import the data from your Excel file, so if the contents of the Excel file change, you only need to refresh your queries.
JMS，
Open the Advanced Editor of the imported query in Query Editor of Power BI Desktop, you can find that the path of Excel file. And when you change data in the Excel file, you can click "Refresh Preview" to get updated data.
Regards,
Lydia
How did you upload the Excel file?
The normal way is to use "Get Data" and import the data from your Excel file, so if the contents of the Excel file change, you only need to refresh your queries.
thanks, let me go back to find where I pulled the original file from, then I cna save over that file with the updated and it should be good to go. Nice when the office is quiet and you can try and figure these new toys out. So glad someone else is at their desk as well!
JMS，
Open the Advanced Editor of the imported query in Query Editor of Power BI Desktop, you can find that the path of Excel file. And when you change data in the Excel file, you can click "Refresh Preview" to get updated data.
Regards,
Lydia