Earlier this week, Anders and I were working with exporting data from Log Analytics to a CSV file. Previously, this has always been done with the API. But nowadays we have an Export button to direct export the result from the current query. On the Export drop down menu we also have the options to export to PowerBI.
From the Export menu we can choose CSV format direct. In the screenshot you can see there is a option to export all columns or displayed columns. Displayed columns are the ones you project in the query. All columns is, in this example, all column in the VMConnect table. We can then easily massage and format the data in Excel if needed. Very quick compared to writing a script exporting the data