Forum Discussion
Importing and merging multiple Google BigQuery tables
Hi all, My client's data is automatically recorded into google big query. Every day a new table is created with a datestamp in the same format. I am importing using import mode. E.g. Todays ta...
Anonymous,
A method is to create a function in your PBIX file, then create a table containing all the date number of today + the previous 30 days, and invoke the function in this table. There is a similar video for your reference.Day_20190204_Table = DB_Schema{[Name="Day_"&Number.ToText(date)&"",Kind="Table"]}[Data]
And you can check the M code in my scenario of the function.(date as number)=> let Source = GoogleBigQuery.Database(null), #"bigquery-public-data" = Source{[Name="bigquery-public-data"]}[Data], austin_311_Schema = #"bigquery-public-data"{[Name="austin_"&Number.ToText(date)&"",Kind="Schema"]}[Data], #"311_service_requests_Table" = austin_311_Schema{[Name="311_service_requests",Kind="Table"]}[Data] in #"311_service_requests_Table"
Regards,
Lydia
Anonymous,
A method is to create a function in your PBIX file, then create a table containing all the date number of today + the previous 30 days, and invoke the function in this table. There is a similar video for your reference.
Day_20190204_Table = DB_Schema{[Name="Day_"&Number.ToText(date)&"",Kind="Table"]}[Data]
And you can check the M code in my scenario of the function.
(date as number)=>
let
Source = GoogleBigQuery.Database(null),
#"bigquery-public-data" = Source{[Name="bigquery-public-data"]}[Data],
austin_311_Schema = #"bigquery-public-data"{[Name="austin_"&Number.ToText(date)&"",Kind="Schema"]}[Data],
#"311_service_requests_Table" = austin_311_Schema{[Name="311_service_requests",Kind="Table"]}[Data]
in
#"311_service_requests_Table"
Regards,
Lydia