Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
6 years ago

Dataflows - any reason not to use a custom SQL script? It's a slight workaround, and I wonder why

In PBI Desktop, when connecting to a SQL server sourcee ,you have an option to write your own query:     In Dataflows though, this option is missing      I can recreate it, by eithe...
Need Help
mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago

v-yingjl 


So is the only reason *not* to use native queries (i.e. custom SQL), is that query folding doesn't occur if one makes additional steps in Power Query? 

To me that's a non-issue.  If you're using a custom SQL/...instead of addtional steps in Power Query - just go back to your original custom SQL & change it there. 


Are there additional reasons I'm missing? 
Is there any other reason not to use native queries? 

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi mmace1 ,

"So is the only reason *not* to use native queries (i.e. custom SQL), is that query folding doesn't occur if one makes additional steps in Power Query? "

No. As I mentioned before, dataflow does not prohibit native query but will pop warning that it is unsafe, and users can get data as normal as desktop as long as they click to continue. It is by design, not have any special reason.

 

 

Best Regards,
Yingjie Li

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