Unable to pull Google BIG QUERY (GCP) Datetime columns to Power BI desktop

[kmanyam]

Hello there , I am unable to pull  Google BIG QUERY (GCP) Datetime columns to Power BI , How do we workaround this issue.

Seeing the following error . Issue is mentioned in the official site (https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery#unable-to-authenticate-with...

just seeing if there is any update on this 

[kmanyam]

It worked only once , i tried to do again , it threw the same error.

[Anonymous]

Hi @kmanyam ,

Do you still get the same error message even if you use custom query and load into Power BI after converting all the fields that were originally of datetime type to date or text type? Could you please provide the related SQL query and screenshot with error message for further troubleshooting? Thank you.

Best Regards

[Anonymous]

Hi @kmanyam ,

You can use a custom SQL query within Power BI to convert the datetime columns into a format that Power BI can handle(for example: Date or Text).

Convert the type of datetime column as Text:

SELECT 
    CAST(datetime_column AS STRING) AS datetime_column_str,
    other_columns
FROM 
    your_table

Convert the type of datetime column as Date:

SELECT 
    CONVERT(date,datetime_column) AS datetime_column_str,
    other_columns
FROM 
    your_table

Best Regards