4 ms·
> but it doesn't operate within Excel's data model Power Query is an Excel add-on, and has been around much longer than Power BI and has nothing to do with it.
by tomnipotent 5y ago
> but it doesn't operate within Excel's data model
Power Query is an Excel add-on, and has been around much longer than Power BI and has nothing to do with it. This has been possible for almost a decade, since Excel integrated a robust in-memory columnar database capable of dealing with millions of rows.
> it would be wrong to pretend like the join is done in Excel
The join is done in Excel, I don't need to pretend. That you think Excel is just a bunch of sheets and cells is your own mistaken mental model of what the program is and can do.
Here's another reference:
"Now that Excel has a built-in Data Model"
https://support.microsoft.com/en-us/office/create-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3 https://support.microsoft.com/en-us/office/create-a-relation...
- dgudkov 5y agoCan you point me to an article that shows a simple way how to do a simple SQL-like join (no aggregation) of two regions in the same spreadsheet? Two source tables, and one result table - all in the same spreadsheet. Something that is as simple as this: https://www.youtube.com/watch?v=RYCtoRTEk84 https://www.youtube.com/watch?v=RYCtoRTEk84
- tomnipotent 5y agoI sent you two links with information, including images that show the process. Here's a video of the process: https://support.microsoft.com/en-us/office/merge-queries-and-join-tables-cbd17828-7a50-4dc6-9aac-20af4ef6d8a6 https://support.microsoft.com/en-us/office/merge-queries-and... Here's another video: https://www.youtube.com/watch?v=BV3srtI20Bo https://www.youtube.com/watch?v=BV3srtI20Bo
- dgudkov 5y agoThank you. I didn't know this. I wouldn't call the process easy, but it's relatively straightforward.