Forum Discussion

hmpatel9's avatar
hmpatel9
Frequent Visitor
8 years ago

Impala Cloudera Direct Query create Date table

Hello all we are trying to connect to Impala using Direct query option . We are able to connect but the date /datetime columns (Timestamp) are coming as text . When we try to change the type to Date the same is not allowed .  When we try to create a Date table that is also not possible as the New table is disabled.

 

I there a way to connect to Impala and have Dates represented in PowerBI desktop Or create a Date table .

Need Help

5 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi hmpatel9,

    You get data using Direct Qury, which means you connect the database directly instead of importing data into Power BI desktop. So we can't change the data type. The date /datetime columns (Timestamp) are coming as text, which shows the provider "Impala" recognize it as text format.

    For your scenario, please right click table as follows, create a calculated column which equals to the date column using the formula below. Then set the calculated columns as date type, and check if it works fine.



    NewColumn = [Date]


    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi hmpatel9,

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia

    • hmpatel9's avatar
      hmpatel9
      Frequent Visitor
      8 years ago

      Hello Angelia .. Thank you for your inputs but I have not been able to solve this issue . WhenI try to change the data type of compluted column data type it gives a error that "Change type is not supprted for this source"