Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.