Forum Discussion

Margisha's avatar
Margisha
Copper Contributor
Apr 30, 2019

Excel 2010 and 2016

I am using Microsoft excel 2010. I am making a document using supplement PowerQuery for Excel 2010. When I open this a document from Excel 2016, i see a mistake: The connection could not be refreshe...
excel
power bi
Power Query
JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 30, 2019
I think the powerquery version you are using for Excel 2010 is newer than the one currently in your Excel 2016 installation. Open the PowerQuery query editor, click "File", "Options and Settings", then click "Query options", "Diagnostics" tab to find the version number of PQ.

Resources