Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Slow Performance when using BigQuery BI engine in Direct Query mode

I start testing BigQuery BI engine with PowerBI using Direct Query mode, when working with a simple measure the performance is ok, but if I add two measures or using something like cumulative sum, the performance became extremely slow, we are talking 10 to 12 seconds, keep in mind BigQuery render in less than a second, so it defintely something to do with PowerBI.



Status: New
Community Support



You may take a look at Optimization guide for Power BI and share feedback via ideas.

Advocate V
Advocate V

@v-chuncz-msft  it is a bug in PowerBI, I have being asked by the one of the PowerBI PM to report it here, which I did 🙂

Regular Visitor

Puzzles me how nothing has been done on this in months since the first post. Are we the only ones facing this performance issue?
I would love to continue using PBI but we need direct query connection and data streaming. At the current status it's impossible.