Are materialized Views not supported in Power BI built on Google BigQuery?
I have created few materialized views in Google BigQuery and tried using Get Data in Power BI to fetch but the MV was not showing in any schema or datasets.
Have connected an ODBC driver for BigQuery to write a standard SQL statement to fetch the MV but it is auto importing only.
There is no option for choosing connectivity mode? Can we not do this in Direct Query? Also is this the only way to connect to Materialized Views (built on BigQuery) in Power BI? @amitchandak please shed some light on this.
I have gone through the above posts before, can you confirm if using Rscript connector it will be possibel to get the connectivity mode option and choose Direct Query for my materialized view built in Google Big Query?