cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Whale27
Frequent Visitor

Are materialized Views not supported in Power BI built on Google BigQuery?

Hi,

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.

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @Whale27 

Here I find a post with similar problem like yours. 

For reference: Power BI with views on Google BigQuery

You can try to connect to BigQuery by R.

For reference: Connect BigQuery With R

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

3 REPLIES 3
Whale27
Frequent Visitor

Hi @RicoZhou 

 

Thanks for the reply.

 

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?

RicoZhou
Community Support
Community Support

Hi @Whale27 

Here I find a post with similar problem like yours. 

For reference: Power BI with views on Google BigQuery

You can try to connect to BigQuery by R.

For reference: Connect BigQuery With R

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

Whale27
Frequent Visitor

Actually Rscript will not solved the problem because i want to leverage Direct Query here, but that's ok. Thanks anyways!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!