cancel
Showing results for 
Search instead for 
Did you mean: 

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
Comments
v-chuncz-msft
Community Support

@mim 

 

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

mim
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 🙂

DaniCons
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.