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

Highlighted
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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 155 members 2,287 guests
Please welcome our newest community members: