How to split columns in Direct Query(source is azure sql database)

[Aparna]

How can I split columns in Direct Query. I am not able to use import because my data is too huge. I have a column that has concatenated details(like a.b.c). I want to split it up into 3 columns, so that I can use the Heirarchy slicer. 

I have 2 tables. One has less data(fact table) and the other is very huge(dimension table). I need to split the column on the fact table so when I get data from only that table i can do an import and split the column, but when I need to get data from the dimension table, it is too huge. I am not able to do a direct query on only one table and an import on the other.

Can anybody tell me how to solve my problem

[v-sihou-msft · Accepted solution]

@Aparna

In Direct Query mode, you can't do any modeling so that calcualted column is not supported. For your requirement, please split those columns via T-SQL query. 

Regards,