Learn how you can use Power Query parameters to make the ETL and data transformation process dynamic inside Power BI solutions or Dataflow solutions in Microsoft Fabric.
Read my article about it here for more information:
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters