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

Power BI with Google BigQuery

Hello, can't find answer on this problem:

How to connect tables through ODBC (google big query), if they have the same structure for each day. i.e:

Sales_history_2017_01_01

Sales_history_2017_01_02 and so on.

I tried to add an SQL statement, but, as I understood, power bi does not support Table_Date _range construction.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: Power BI with Google BigQuery

Hi @Zzema,

 

Have you tried the Append option or Table.Combine(M) to combine all the sales history tables which have the same structure into a single table? Smiley Happy

 

Table.Combine({Sales_history_2017_01_01, Sales_history_2017_01_02, Sales_history_2017_01_03})

 

Regards

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Power BI with Google BigQuery

Could you do an Append query? Perhaps I am not understanding what you are going for though.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Microsoft v-ljerr-msft
Microsoft

Re: Power BI with Google BigQuery

Hi @Zzema,

 

Have you tried the Append option or Table.Combine(M) to combine all the sales history tables which have the same structure into a single table? Smiley Happy

 

Table.Combine({Sales_history_2017_01_01, Sales_history_2017_01_02, Sales_history_2017_01_03})

 

Regards

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors