Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago
Solved

BigQuery: facing issue when access views

Hello All,   I'm trying to access a BigQuery view in PBI Desktop. unfortunately I'm getting the below error,   DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Inval...
  • SivaMani's avatar
    7 years ago

    Solved by disabling the SQL Dialect option - Use Legacy SQL.