DataSource.Error for companion xlsx and pbix files

by | Oct 24, 2018

Book Q&A › Category: Generic Book-Related › DataSource.Error for companion xlsx and pbix files
0 Vote Up Vote Down
David asked 8 years ago
Hi Gil, I'm a newbie and enjoy learning from your book. How do I NOT have to correct data source settings for every practice files? I put them in same C: folder structures as it shown in the error. Error text DataSource.Error: Could not find a part of the path 'C:\Data\C02\C02E02.xlsx'. Details: C:\Data\C02\C02E02.xlsx Thanks.
3 Answers
1 Vote Up Vote Down
Best Answer
Gil Raviv Staff answered 8 years ago

Quick update: Now, the folders in the companion Zip file are in the format C01, C02, etc. So readers can simply move the folders into C:\Data, and all the solution files will work.

0 Vote Up Vote Down
Gil Raviv Staff answered 8 years ago
Hi David, Could you please confirm that you saved the files under C:\Data\C02? I suspect that you used the folder stucture that was provided in the ZIP file, which is 01, 02, 03,... instead of C01, C02, C03 and so forth. If you still have an issue, can you share a screenshot from File Explorer with the source files, and an additional screenshot of the error in Power Query Editor? Thank you,
Gil
0 Vote Up Vote Down
David answered 8 years ago

Gil,

I corrected it following your instructions (put C in folder names) :) and it worked.

Thanks!