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
mow700's avatar
mow700
Icon for Resolver I rankResolver I
8 years ago

I do get the option for direct mode.  Have you updated your version of the PBI Desktop recently?

I'm using Version: 2.51.4885.701 64-bit (October 2017)

 

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