cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pstanek Member
Member

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 source. ".

 

I read many topics about this  , but l was not able to find solution to this problem.

5 REPLIES 5
zoloturu
Advisor

Re: OLE DB or ODBC error: [Expression.Error]

Hi @pstanek,

 

  1. Are you able to successfully refresh report?
  2. Provide example of your DAX measure and visual you want to add.

 

Regards,

Ruslan

pstanek Member
Member

Re: OLE DB or ODBC error: [Expression.Error]

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

I have date and time formated  as textDate and time big query.GIF

 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

Formát Power Bi.GIF

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

 

Visual is only number, It represents hours between two events

zoloturu
Advisor

Re: OLE DB or ODBC error: [Expression.Error]

Hi @pstanek,

 

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

 

Regards,

Ruslan

pstanek Member
Member

Re: OLE DB or ODBC error: [Expression.Error]

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

pstanek Member
Member

Re: OLE DB or ODBC error: [Expression.Error]

Hi I met this mistake in another case.

I have slicer  shop name in some report, when I  choose one shop, It will calculate result.

But when I choose another It shows  the same mistake. It is happened because Power BI is not able to create SQL query to Big Query.