I'm trying to use Value.NativeQuery with ODBC coomection to Big Query And get Error
Original Code:
let
Source = #"Odbc/dsn=Google BigQuery",
#"prod_Database" = Source{[Name="prod",Kind="Database"]}[Data],
default_Schema = #"prod_Database"{[Name="default",Kind="Schema"]}[Data],
DW_DIM_Table = default_Schema{[Name="DW_DIM",Kind="Table"]}[Data]
in
DW_DIM_Table
New Code
let
Source = #"Odbc/dsn=Google BigQuery",
MyQuery = Value.NativeQuery(#"Odbc/dsn=Google BigQuery", "SELECT * FROM `default`.DW_DIM")
in
MyQuery
Error:
The query statement is not valid.
When I'm trying Put the statement to Power Query Editor:
= Value.NativeQuery(#"Odbc/dsn=Google BigQuery", "SELECT * FROM `default`.DW_DIM")
get Error
Expression.Error: Native queries aren't supported by this value. Details: Table
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)