How to use CETAS on serverless SQL pool to improve performance and automatically recreate it

TePeBox  Once you create the CETAS the file will always be there for consumption until you drop the CETAS. Then, once you drop it on serverless... actually the file still be there, unless you delete manually the file. Because from a serverless perspective this is a metadata operation, only.  So you do not need to recreate the same file over and over again for Power BI consumption, it will be there. However, if the data inside of this CETAS file must be updated, then you need to drop and recreate it. My suggestion is to use the ADF to do it, in my scenario my customer (who inspire the post) would do this once per day ( at night) and use it for reports during the day. The time of the CETAS update and the report would not overlap because the ADF pipeline was scheduled as JOB out of business hours. MrAndyCutler kindly also shared a very interesting solution. 

But I believe your point is to connect this operation of updating the CETAS to a refresh on the power bi, which would update the file automatically. right? Because you want to refresh hourly, so you want fresh data in a regular interval that may overlap with the ADF. My example does not cover such a scenario, my scenario ADF schedule and reports should not overlap, but thanks for the suggestion. Let me think it over.