Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Google Bigquery Direct Query Mode

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I am using the October 2017 release of Power Bi Desktop. I am never shown that option.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous, toulou,

 

The Google BigQuery (Beta) connector should 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. :smileyhappy:

 

Regards

  • toulou's avatar
    toulou
    Frequent Visitor
    8 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

     

    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.