The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
We are planning to use PB Embedded with A1/A2 capacity. However I need some clarity as I could not find clear answer of my question in any thread yet.
I know there is 5QPS limit with A1 cpacity but is this Direct query can also work with On-premises SQL Server? If No then what if we use Gateway then still we can't use On-premises SQL Server in Embedded flow?
Thank you.
Solved! Go to Solution.
Thank you @v-jiascu-msft. I was expecting to get expert confirmation on direct query. Anyhow I have prepared environment and tested/confirmed it. (For other newbie) Answer for my question was :
We can use Diect Query or Periodic Schedular of datasets using Data Gateway with acceptable performance.
Hi @malikirfan28,
Could you please tell me where you got this information? Please also refer to understanding-the-power-bi-capacity-based-skus/ and power-bi-premium-pricing-model-good-bad-ugly/.
Best Regards,
Dale
Thank you @v-jiascu-msft. I was expecting to get expert confirmation on direct query. Anyhow I have prepared environment and tested/confirmed it. (For other newbie) Answer for my question was :
We can use Diect Query or Periodic Schedular of datasets using Data Gateway with acceptable performance.
User | Count |
---|---|
39 | |
14 | |
12 | |
12 | |
11 |
User | Count |
---|---|
49 | |
35 | |
24 | |
21 | |
18 |