Forum Discussion
RuchiSharma
3 years agoFrequent Visitor
How can we change the ODBC data source in direct query mode Using M-query?
How can we change the ODBC data source in direct query mode Using M-query?
3 Replies
- parry2k
Super User
RuchiSharma Once you have import mode, nothing out of the box is available to change it to DQ mode. There are community tools around that can assist, just search on google. Keep in mind, not all the sources can be used for DQ.
- RuchiSharmaFrequent Visitor
parry2k Thanks for your response. But I am asking how to chnage using M-query/Custom code.
- RuchiSharmaFrequent Visitor
parry2k To understnd my question please refer this link : https://learn.microsoft.com/en-us/power-query/odbc It will help you to understand my problem. Thanks!!