Hello All,
I'm struggling with memory issues when using Power Query or Power Pivot for a very large dataset. So I'm looking for ways to cut down on the 'returned' data. Here is the scenario. I have 2 tables, on called GL_Summary and one called GL_Detail. The GL_Summary has about 10,000 entries (no problem returning all of them), but the GL_Detail table has about 700,000 entries which is crazy slow to bring into Excel. There is a relationship between the two tables on a field called JournalEntryBK (it is a one to many relationship). There is a field in the GL_Summary table called AccountBK (this field is not in the GL_Detail table).
I'm trying to (via a Pivot Table or Data Model) find a way to select an AccountBK in the GL_Summary table and then return all of the corresponding entries that have a matching JournalEntryBK in the GL_Detail table. I've messed around with different ways for a few hours, but cannot figure it out. Any ideas??
I'm struggling with memory issues when using Power Query or Power Pivot for a very large dataset. So I'm looking for ways to cut down on the 'returned' data. Here is the scenario. I have 2 tables, on called GL_Summary and one called GL_Detail. The GL_Summary has about 10,000 entries (no problem returning all of them), but the GL_Detail table has about 700,000 entries which is crazy slow to bring into Excel. There is a relationship between the two tables on a field called JournalEntryBK (it is a one to many relationship). There is a field in the GL_Summary table called AccountBK (this field is not in the GL_Detail table).
I'm trying to (via a Pivot Table or Data Model) find a way to select an AccountBK in the GL_Summary table and then return all of the corresponding entries that have a matching JournalEntryBK in the GL_Detail table. I've messed around with different ways for a few hours, but cannot figure it out. Any ideas??