Direct Query Connection tables result as Direct Query instead of Import

[prakash11440278]

Hi All,

I am using two tables which i imported those as Direct Query connection. I created a new calculated table by using those two direct query connection tables. I selected few columns and created a new calculated table using union function. Now my isuse is i want the new calculated table also be from direct query instead of import connection. Is it possible to convert the newly created calculated table as direct query?

[lbendlin · Accepted solution]

which i imported those as Direct Query connection

poor choice of words, eh?  🙂

Anyway, you can only convert from Direct Query to Import mode. You cannot (officially) covert back.  You will need to start over.

Can you do the Union at the data source?