Google Bigquery Direct Query Mode

Question

I can't seem to be able to get the new Bigquery connector to let me use Direct Query mode. this is a fresh project and I re-set the credentials but I am never given an option to choose mode or enter a query.

How can I get to Direct Query mode?

v-ljerr-msft · Answer

Hi&nbsp;Anonymous,&nbsp;toulou,
&nbsp;
The Google BigQuery (Beta) connector should&nbsp;support DirectQuery in Power BI Desktop from the August 2017 update. If the issue persists, I would suggest you create a support ticket on Power BI Support page for better assistance.&nbsp;:smileyhappy:
&nbsp;
Regards

toulou · Answer

It seems to work now. Only isse I am seeing is if you have connected to one source in DirectQuery mode and then want to add another BQ source in Query Editor. In those cases it doesn't show the option DirectQuery.&nbsp;

anonymous · Answer

It seems that I can not use direct query in a project that is also using mysql because mysql does not support direct query and you can not use both modes in one project.&nbsp;Also a big problem with the Bigquery connector is that you can't enter in a query. So I had to use the ODBC connector.

mow700 · Answer

I do get the option for direct mode.&nbsp; Have you updated your version of the PBI Desktop recently?I'm using&nbsp;Version: 2.51.4885.701 64-bit (October 2017)&nbsp;