Selecting _PARTITIONTIME from Bigquery Table Options

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