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

 

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

Need Help

5 Replies

  • zoloturu's avatar
    zoloturu
    Icon for Memorable Member rankMemorable Member
    8 years ago

    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's avatar
      pstanek
      Icon for Post Patron rankPost 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
        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

    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.