Forum Discussion

Copper Contributor

Jul 04, 2017

'Data could not be retrieved from the database' error when using power query to get data from xlsx

I was using 'Power Query' addin in Excel 2010 to get data from an old .xlsx file. It was working perfectly fine and loading data into table in current workbook until I 'Unpivoted' some columns. I don...

BI & Data Analytics

Need Help

alexcabramson

Copper Contributor

Oct 07, 2020

Guy Hunkin

Hi Guy,

I've just hit this same problem where I get the "Data could not be retrieved from the database" error when including an unpivot in my power query. Do you know if this flaw has been fixed in the several years since Qiong brought it up?

Thanks,

Alex

Guy Hunkin

Microsoft

Oct 15, 2020

alexcabramson , it should have been fixed. I encourage you to update to the latest version and try if it works.

Guy

- Excel Team