Home

Power Query version compatibility

%3CLINGO-SUB%20id%3D%22lingo-sub-894132%22%20slang%3D%22en-US%22%3EPower%20Query%20version%20compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-894132%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3ERecently%20I%20was%20hired%20as%20a%20contractor%20to%20develop%20some%20complex%20power%20pivot%20reports.%20The%20version%20being%20used%20was%20Excel%202010.%20I%20used%20Power%20Query%20to%20get%20and%20transform%20data.%20The%20company%20is%20upgrading%20to%20Excel%202013.%20I%20found%20that%20I%20could%20not%20upgrade%20through%20Excel%202013%20due%20to%20power%20Query%20issues%2C%20so%20I%20have%20rebuilt%20the%20reports%20in%20Excel%202013.%20Simpler%20power%20pivot%20reports%20that%20did%20not%20use%20power%20query%20upgraded%20with%20no%20issues.%20My%20question%20is%3A%20Are%20there%20any%20compatibility%20issues%20should%20the%20company%20upgrade%20from%20Excel%202013%20to%20Excel%202016%2C%20Office%20365%2C%20or%20Excel%202019%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20input.%20%3B%26gt%3B)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-894132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
rgpress
Occasional Visitor

Hi

Recently I was hired as a contractor to develop some complex power pivot reports. The version being used was Excel 2010. I used Power Query to get and transform data. The company is upgrading to Excel 2013. I found that I could not upgrade through Excel 2013 due to power Query issues, so I have rebuilt the reports in Excel 2013. Simpler power pivot reports that did not use power query upgraded with no issues. My question is: Are there any compatibility issues should the company upgrade from Excel 2013 to Excel 2016, Office 365, or Excel 2019?

 

Thanks for your input. ;>)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies