Forum Discussion

pstanek's avatar
pstanek
Post 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
pstanek's avatar
pstanek
Post Patron
8 years ago

HI . I tried to refresh it and nothing has happened.

I have date and time formated  as text

 When I try to change type in Queryditor ,  Error will appear. Direct Query does not support it.

 

Measure is 

Hodiny = HOUR(MAX(table[datumcas]))-HOUR(MIN(table[datumcas])).

When datumcas is text, it can´t calculate.

 

 

So I Try to change format here

 and OLE DB or ODBC error: [Expression.Error] will appear.

 

Visual is only number, It represents hours between two events

zoloturu's avatar
zoloturu
Memorable 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
    Post 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