Refresh Error Cloud and On Premise

Hii DPCCGF 

I find the issue as this please try the relevent solutions given as per the Microsoft learn docs:

This error is that Power BI is preventing the refresh of a cloud data source through an On-Premises Data Gateway, which typically happens when you're trying to combine a cloud source (like SharePoint Online, Azure SQL, etc.) with an on-premises source (like Excel on a local drive or network) in the same semantic model and attempting to refresh it using a gateway.

Some Solutions you can try are as (Multiple given which works for you):

1. Move Both Sources to the Same Environment

To ensure compatibility:

• Either move the Excel file to a cloud location (e.g., OneDrive or SharePoint Online), OR

• Use only on-prem sources and handle both through the gateway.

2. Use Dataflows to Separate Refresh Paths

• Create Power BI Dataflows for either the cloud or on-prem source.

• Let the Dataflow handle cloud-source refreshes (as it refreshes in the cloud directly).

• Then use the result in your semantic model and avoid mixed-mode gateway refresh.

3. Use Import Mode + Power Query to Decouple

• Load the sources separately using Import mode, and avoid merging cloud and on-prem sources directly in Power Query.

• Use intermediate tables and relationships instead of direct merges within Power Query.

If you need further help let me know.

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