Forum Discussion
Power Query Append Repeatability Issue
I'd avoid using of extra intermediate workbook. You may do everything in another workbook - combine two sources by Power Query, load result in data model (not to the table in the grid) and build PivotTable based on data model. Alternative land Power Query directly in PivotTable.
Sure, Access and even MS SQL Server with related tools are more powerful, but before shifting on them check again if you did all performance optimizations.
Chris Webb has series of posts around that Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge Chris Webb's BI Blog (crossjoin.co.uk), you may find other advices.
I'd avoid using of extra intermediate workbook. You may do everything in another workbook - combine two sources by Power Query, load result in data model (not to the table in the grid) and build PivotTable based on data model. Alternative land Power Query directly in PivotTable.
Sure, Access and even MS SQL Server with related tools are more powerful, but before shifting on them check again if you did all performance optimizations.
Chris Webb has series of posts around that Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge Chris Webb's BI Blog (crossjoin.co.uk), you may find other advices.
- Thank you so much. As a temporary solution I dumped all completed data into a Access database and noticed my refresh time dropped dramatically. Refresh is only 49 seconds compared to the 5 1/2 to 6 minutes refresh via Excel.
I'll read into this link you provide. Thank you!
