Selecting _PARTITIONTIME from Bigquery Table Options

[jbovet]

Hi all,

We are curently testing Power BI for our work project and trying the bigquery connector. Unfortunately, the Bigquery connector does not support direct SQL, and we can only retrieve whole tables.

Now, we can see the detailed query in advanced mode :

let
    Source = GoogleBigQuery.Database(null),
    #"projet" = Source{[Name="projet"]}[Data],
    table_Schema = #"projet"{[Name="dataset",Kind="Schema"]}[Data], 
    table_Table = dataset_Schema{[Name="table",Kind="Table"]}[Data]
in
    table_Table 

But this query does not retrieve meta columns such as _PARTITIONTIME. Is it possible to select _PARTITIONTIME in the advanced mode and turn it into a regular date column in Power BI ? Thanks a lot for your help, Julien

[v-yuezhe-msft · Accepted solution]

@jbovet,

A method is to create an ODBC data source for Google BigQuery , then connect to this ODBC source in Power BI Desktop and write specific statement to get data.

Regards,
Lydia