As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your ...

– You can use a graphical user interface like MySQL Workbench or phpMyAdmin to execute your SQL query. – If you prefer using the command-line interface, you can connect to the database server using a ...

Next I have the all-important Transform data using Power Query action. At the moment you can only use Power Query with SQL Server data sources, and (at least when I tested it) it only seems to work ...

While you can type any query you might like, it suggests possible questions based on your data in your app at the time. Note that Copilot over SQL supports an additional verb “in” that SharePoint does ...