Impala Cloudera Direct Query create Date table

[hmpatel9]

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 .

[v-huizhn-msft]

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]

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"

[theronarmandm]

Is there an answer for this question 

[RMDNA]

@theronarmandm,

Try not to revive old threads, but yes, there is an answer.

As Angelia said, you can only change datatypes, etc. in Import mode; in DirectQuery, you're pulling data directly from the datasource, so if you want anything changed, it needs to be done in the backend (i.e. change the datatype in Impala).

[v-huizhn-msft]

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