Hi Mynda
When practicing the 3.02 Worksheets not correctly formatted, the formula followed in the blank query return the following error:
DataSource.Error: The process cannot access the file 'C:UsersyesinOneDriveDesktopYO PersonalmyOnlineTraining_PowerQuery, PowerPivot & Dashboard Online CoursePractice Filespq_3.02.xlsx' because it is being used by another process.
Details:
C:UsersyesinOneDriveDesktopYO PersonalmyOnlineTraining_PowerQuery, PowerPivot & Dashboard Online CoursePractice Filespq_3.02.xlsx
When I close the file and redo the query, it works but the close and load is in a separate workbook.
What am I doing wrong?
Thanks
Yesintha
Hi Yesintha,
When you get data from an external Excel file, that file must be closed for Power Query to get the data. You're getting that error because the source file is open.
In my example, the query is also loading the data into a different workbook to the source. You're doing it correctly.
Mynda
Thanks very much!
