Google Big query and data views

[Anonymous]

Hi,

I am trying to used direct query connector for Google BigQuery and Power BI.  I am being asked to connect with a data view.  I am unable to see the view from Power BI and the only thing I can discover is that the query has the setting 'Use Legacy SQL = "Yes"  the two views I can see have this set to "No"  

What I know:  Using ODBC connection I can not do a direct query, only import.

Using the connector, I can not write my own select.  

Does anyone have any experience with this? I would apprecate your guidance.  

Suzanne

[v-frfei-msft]

Hi @Anonymous ,

Based on my research, it is not supported yet currently. In your scenario, we can filter the data in power query to work ar ound. Btw, There is an idea and about that you can vote it up and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18643924-disadvantage-in-direct-query-mode-every-action-d