Forum Discussion
Using M-code in the Advanced Editor to load data in the Direct Query Mode
Thanks Anand24 , Allow me to offer another insight:
Hi, chenchen_voc
If you want to use Direct Query mode when connecting to Snowflake, then you need to use the officially certified Snowflake connector, you can refer to the following official documentation:
Power Query Snowflake connector - Power Query | Microsoft Learn
If you use M code, as you say by super user, you won't be able to convert to Direct Query mode.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anand, thanks for your reply.
However, I can not convert this table into direct query mode. It has been set the import mode by default when I load the table with the M query. So I can not change it as your solution showed.
Thanks!
Chen
Thanks Anand24 , Allow me to offer another insight:
Hi, chenchen_voc
If you want to use Direct Query mode when connecting to Snowflake, then you need to use the officially certified Snowflake connector, you can refer to the following official documentation:
Power Query Snowflake connector - Power Query | Microsoft Learn
If you use M code, as you say by super user, you won't be able to convert to Direct Query mode.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.