Import Mode to DirectQuery - Mixed Model

[seryan]

Hello

I have a Snowflake star schema model with a fact table and 5 dim tables. To improve performance, I opted to try and make 2 of those dims a Import instead of DirectQuery. When I made this change Snowflake did not seem to support having a mix of direct query and import, it gave me an error. So, I had made a backup of the original all directquery model and re-published it to go back to the original model. Now, it seems to have cached to the mix model and I still get the same error. Looking for help and guidance on how to go back to DirectQuery mode for the entire query where I won't have these errors any longer. As a note, the error I post below never occurred prior to the change and I am just dragging simple/raw fields (no DAX or calcs involved).

[Anonymous · Accepted solution]

Hi @seryan ,

Based on the information you provided, you are using the Import Mode instead of the DirectQuery Mode, which makes the datasource change to a Mixed Mode. What you need to realize is that DirectQuery Mode can be transformed into Import Mode, but the transformation is irreversible. You need to re-upload the original data source all in DirectQuery Mode to get the results you want.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}