OLE DB or ODBC error: [Expression.Error]

[pstanek]

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.

[pstanek]

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.

[zoloturu]

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]

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]

Hi @pstanek,

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

Regards,

Ruslan

[pstanek]

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