Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
After running the SQL for the first time in Import or Direct, is advanved editor the only location to perform edits ?
How would one get to the SQL Import/Direct mode window which is much easier for query edits.
Advanced editor syntax is difficult to cope up with where it adds (#IF) , (IF)...
Any tips on how to just replace the entire SQL in advanced editor with edited one ?
Solved! Go to Solution.
Are you looking to change from direct to import or just change the SQL query?
If it's the latter, you can make changes in the Applied Steps inside the Power Query Editor - just click on the Source step and click the settings cog next to it. This will bring up the SQL Server Database options window again and allow you to change the Advanced options SQL statement.
You can also look at the 'Data Source Settings' option in the drop down under Transform Data - this will enable you to change the settings for all queries of the same source, rather than having to go into each query's source step and change there. Just depends what you're trying to change.
Hope that helps, please mark as a solution if so. If not, let us know more details. Thanks!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Are you looking to change from direct to import or just change the SQL query?
If it's the latter, you can make changes in the Applied Steps inside the Power Query Editor - just click on the Source step and click the settings cog next to it. This will bring up the SQL Server Database options window again and allow you to change the Advanced options SQL statement.
You can also look at the 'Data Source Settings' option in the drop down under Transform Data - this will enable you to change the settings for all queries of the same source, rather than having to go into each query's source step and change there. Just depends what you're trying to change.
Hope that helps, please mark as a solution if so. If not, let us know more details. Thanks!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com