Furthermore, these visuals don’t have a 30-year history to them, so they feel “more modern” than Excel, even though Excel has made significant strides in that department lately.
Excel query table wait for ready pro#
Ich bin ein Excel Pro myself, as I’ve said before, and in the early days of Power BI Desktop’s existence, I kept it at arm’s length. I am 100% sympathetic to the Excel Pro stance of resisting new tools. …how hard is it to pick up Power BI Desktop if you are already competent with Power Pivot? (and perhaps also with Power Query?) But First… WHY Make the Jump at All? SHOULD We? So, given that there’s a sizeable number of humans using the Excel version of these tools, and that the Excel version is by far the best “on ramp” to the new languages of DAX and M, it’s a natural question… It wasn’t until recently that we were given ANOTHER place, in the form of Power BI Desktop, where we could use those incredible analytical engines.Īnd even today, Excel remains REMAINS the best STARTING place for the world’s tens of millions of Excel Pros (who I have long defined as “anyone who uses PivotTables, VLOOKUPS, and/or SUMIF multiple times per week.”) We’ve seen this over and over again, both with other tools like Tableau and now with the new Power BI: these Excel folks are quite wary of new tools, leading to widespread poor adoption. For 5+ years, Excel was the ONLY “place” where we could get our hands on the awesome power of the DAX engine (aka Power Pivot) and the M engine (aka Power Query).