PowerApps embedded in Power Bi Desktop communication to Local SQL Server without on Premises

[ramakrishnans]

I have created a Power app in the Power apps portal. This power app communicates to one of my databases via an on-premises gateway. On a button click on the power app embedded in the Power BI Desktop, few selected data is passed as a parameter to a procedure which runs in my database.

I am using this power app embedded in my Power BI Desktop template. 

Power BI Desktop -> Power Apps -> DB (via on Premises Gateway)

Power app works only with the internet.

Is it possible to make power app communicate to my local database without any network connections? (without on-premises or cloud databases) 

If no, then is it possible to redirect the power app communication to the appropriate db gateway by passing the parameter(gateway name) from Power BI Desktop from which the request originated?

[v-juanli-msft]

Hi @ramakrishnans

I'm afraid it is not possible for both your requirements.

when you embeded PowerApps in Power BI Desktop, you use the dataset from PowerApps, while this dataset connect to PowerApps from local SQL Server via on premises gateway, it is a normal and neccessary work flow.

Best Regards
Maggie