Forum Discussion
Import Mode to DirectQuery - Mixed Model
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).
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.
1 Reply
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.