Dynamic Dashbaord

Hi AhmedTh32 

According to your description, you can configure refresh to fulfill your needs. After configuring refresh for the data source, the data can be automatically triggered to update according to the refresh frequency setting without manual operation. Please refer to the following steps for specific operation. 

1. If your data source is local, then you need to configure the gateway, you can refer to the following documents： 

What is an on-premises data gateway? | Microsoft Learn 

Install an on-premises data gateway | Microsoft Learn 

2. If your data source is in the cloud, you can configure refresh without installing gateway: 

Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn 

Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn 

Manage connections and gateway: 

3. After installing and configuring the gateway, you also need to add the relevant data source on the Power  BI Service, as well as your semantic model and the gateway to map, specifically refer to the following documents: 

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn 

Manage a SQL Server data source - Power BI | Microsoft Learn 

Manage your data source - import and scheduled refresh - Power BI | Microsoft Learn 

Data refresh in Power BI - Power BI | Microsoft Learn 

Add the relevant data source

Semantic model and Gateway Mapping:

4. After ensuring that the semantic model is manually refreshed, you can configure scheduled refresh to automatically refresh the model according to the time setting. 

Configure scheduled refresh - Power BI | Microsoft Learn 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.