PowerQuery: Avoid reload every time a column is added

Question

How can I avoid a complete reload from the e.g. SQL Server every time I add / change a custom column in PowerQuery? I'd like PowerQuery to work with the local (Data Model) data only unless I hit the refresh button.

Alejandro Lopez-Lago - MSFT · Accepted Answer · 2017-08-20 17:03:49Z

3

You can use Table.Buffer to keep the table in memory for subsequent calculations.

answered Aug 20, 2017 at 17:03

Alejandro Lopez-Lago - MSFT

4,18422 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PowerQuery: Avoid reload every time a column is added

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related