Issue with Configuring Gateway for Power BI Service - Unable to Refresh Report with Import and DQ

Hello Power BI Community,

I am currently facing an issue with configuring the gateway in Power BI Service for a report that involves two tables: one using Import mode and another using DirectQuery mode.

The Import table is utilized by an R script in Power Query, while the DirectQuery table originates from an SQL endpoint created in Fabrics warehouse. The tables are not directly connected except  DAX measures. Locally, I can successfully refresh the report in Power BI Desktop.

However, upon publishing the report to Power BI Service, I encounter challenges setting up the refresh and gateway. For the Import table, I am restricted to using the personal gateway (due to R script), whereas the second source requires a cloud connection. Unfortunately, Power BI Service does not allow me to configure the gateway for the DirectQuery table (attached is a screenshot).

Both sources are set as public privacy levels, and the connections have been individually tested and are functional. However, they are not accepted by Power BI Service when included in the same file. I am seeking clarification on whether it is possible to establish such a connection in Power BI Service.

Attached is a screenshot for your reference.

Thank you for your guidance in resolving this matter.