Update Power BI Dashboard

Hi rpjheeney，
Thanks for aduguid relpy。
Based on your description, if you want to update the dashboard and want to apply the steps before power query. The best way is to configure refresh for the dataset. the steps in power query are automatically applied to the new data. In power bi service, a timed refresh will make it easier to update your dashboards in time when you have changes in your data.
Managing query refresh - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly