Modify schema - only works for push datasets?

Is it possible to add or remove columns from dataset, outside of push data sets?

This API looks to do exactly what I need: https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable

However it only works for push datasets and the dataset I'm working with is too large for that, so I'm using direct query.

Ultimately I want a way for a change to the SQL Server view I'm connecting to to be reflected in queries to the dataset. Is there any way I can do this?