is there any way to change source from excel to desktop folder

[anglefbi11]

guys i created a power query for powerbi by taking the data from single file xls which in my pc.  now i changed my mind and i need the data to be from folder which in my desktop instead of single xls file.

is there a way to solve this problem?

[Greg_Deckler · Accepted solution]

@anglefbi11 Create a folder query. Copy and paste the M code for your transformation into the Transform Sample File query. Remove old query, rename Folder query to the old query name.