Deployment Pipeline - Management of calculated tables (currently needs a dataset refresh)

Currently, when you deploy a dashboard with a dataset containing calculated tables, once the deployment is complete, the dashboard no longer works.

This is because the calculated tables require the dataset to be refreshed for the dashboard to work again.

This is not acceptable from a user point of view, as the dashboard is no longer available until the dataset refresh is complete (depending on the dataset, this can take a few minutes, sometimes more than an hour in the case of large volumes).

Details of the problem can be found here: https://community.fabric.microsoft.com/t5/Service/Deployment-Pipeline-Error-with-calculated-tables-dataset-refresh/m-p/4327021#M259145