Use direct query and then import

Question

Hello&nbsp;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?&nbsp;I'm using Power bi&nbsp;2.106.883.0 64-bit (June 2022)&nbsp;Many thanks.

newcolator · Accepted Answer

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

Forum Discussion

Use direct query and then import

2 Replies

Related content

Direct Query or Import

direct query vs. import

Direct Query vs Direct Import

Direct Query to Import

Import to direct query mode