Forum Discussion
Can't transform data using microsoft .xslx sample file
PowerBiNovice_1 , This happens when the path changes. Can you make sure the path is correct?
You can use the edit data source setting and give the correct path
How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY
Hi, thanks for replying, I think this won't be solved as the file referenced by the error ("ProcurementObfuscatedData.xlsx") is not available to download in the microsoft web site, maybe the sample microsoft file was just meant to be used in order to build reports/dashboard/create measures but never intended us to use power query on it, you can try for yourself, download this file below, even if you point it to the correct path where you downloaded it in the data source settings you still get errors:
https://github.com/microsoft/powerbi-desktop-samples/blob/main/powerbi-service-samples/Procurement%20Analysis%20Sample-no-PV.xlsx