Forum Discussion
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) Invalid query: Cannot reference a legacy SQL view in a standard SQL query. Details: DataSourceKind=GoogleBigQuery DataSourcePath=GoogleBigQuery OdbcErrors=Table
Any help would be greatly appreciated!
Solved by disabling the SQL Dialect option - Use Legacy SQL.
1 Reply
Solved by disabling the SQL Dialect option - Use Legacy SQL.