Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
8 years ago

OLE DB or ODBC error: [Expression.Error]

Hi ,I use Biq Query (database) and Direct Query. When I try to  create visual with measures, an error occurs like "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data...
Need Help
zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
8 years ago

Hi pstanek,

 

Can you post here your Power Query code (M) from an advanced editor?

 

Regards,

Ruslan

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
8 years ago

let
Zdroj = GoogleBigQuery.Database(null),
#"bi-data-2073" = Zdroj{[Name="bi-data-2073"]}[Data],
data_lekarny_Schema = #"bi-data-2073"{[Name="data_lekarny",Kind="Schema"]}[Data],
table_View = data_lekarny_Schema{[Name="table",Kind="View"]}[Data]
in
table_View