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 ...

This works fine with regular ADF pipelines but not at run time when the Power Query spark engine is engaged. ... 1 - Use the Web Table activity to read from Wikipedia and write to Azure SQL table.