Sometimes when you are building a query with a lot of steps, you end up going down the wrong path. Double Click to Hide or Show the Query Editor Ribbon.Copy and Paste Queries to a New Workbook.Disable the Auto Detect Data Type Feature.Navigate Through Complex Query Dependencies.Rename a Column with a Keyboard Shortcut.Add Comments with the Query Step Properties.Add Comments that Stay Visible in the Formula Bar.Add Comments Without Opening the Advanced Editor.Comments in Power Query Formula Language.Display a Monospaced Font in the Query Editor.Automatically Add a Row Index to any Query Loaded to a Table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |