Forum Discussion
Vlookup to find multiple variations of a text string
For me, what the documentation suggests and what actually happened were not the same thing. Power Query and Power Pivot both installed despite my not having the correct version of Office.
Now I am using Office 365 insider but that is because I was desperate to evaluate modern Dynamic Arrays (they are superb and now provide the basis of everything I do outside Power Query).
PeterBartholomew1 wrote:
For me, what the documentation suggests and what actually happened were not the same thing. Power Query and Power Pivot both installed despite my not having the correct version of Office.
Now I am using Office 365 insider but that is because I was desperate to evaluate modern Dynamic Arrays (they are superb and now provide the basis of everything I do outside Power Query).
Hi Peter,
Yes, I agree with both.
Documentation could be outdated. That was with "Where is Power Pivot" when expanding of Power Pivot on all SKU was announced first on uservoice, and doc was updated only in a while. Sometimes delay could be quite significant. However, I don't think there were some changes for outdated 2010.
Power Query becomes less important if you work within one notebook. My main scenarios of usage is to pick-up and transform data from different sources (SQL databases, files on SPO and like) to combine in one workbook with its local data. That was I did with Pivot Table connectors long ago, now PQ is the main tool.