Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.