Use direct query and then import

[Newcolator]

Hello

I've connected Power BI to Snowflake and run a direct query to reduce the data down to just what I need. Now I want to take that DQ table and convert it to imported to run some Power BI transformations that can't be done in direct query. I want to keep the DQ part to run first, then create a new imported version of the table. I believe this may be possible with a composite model, but I'm not sure how to do it. Maybe it's not possible to have it both ways for the same table, I'm not sure. Can anyone help?

I'm using Power bi 2.106.883.0 64-bit (June 2022)

Many thanks.

[Newcolator · Accepted solution]

I managed to solve it. You can change the table storage type to imported on the relationships screen. 

[v-easonf-msft]

Hi, @Newcolator 

It's pleasant that your problem has been solved.

Please accept your reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason