Power BI Embedded - On Premise SQL Server Gateway for DirectQuery

Hi burcumusaoglu ,

About Direct Query limitations, The general limitations on directquery apply to all directquery models. No distinction is made between in power bi service and power bi embedded.

Limitations on Direct Query:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#considerations-and-limitations 

Gateway:

With Direct Query model, you need On-premises data gateway (Standard).

Power BI Embedded:

You need to be aware of the DirectQuery/Live connection (per second) and Max memory per query in direc query mode for some power bi embedded sku's.

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-capacity?tabs=gen2#sku-memory-and-computing-power 

As far as I know, you can connect to one or more local services with a gateway via direct query mode.

Best Regards

Community Support Team _ chenwu zhu

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