Forum Discussion
Can't transform data using microsoft .xslx sample file
Hello,
I downloaded the following file from Microsoft in order to practice with a dataset (it's one of their sample data sets):
https://github.com/microsoft/powerbi-desktop-samples/blob/main/powerbi-service-samples/Procurement%20Analysis%20Sample-no-PV.xlsx
I imported it using power bi desktop, but when I clic on "Transform Data" I get the following error in every single table, examples:
Could somebody point me in the right direction to fix that error so that I can transform the data using power query?
Thanks!
2 Replies
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
