When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: You can choose a table from the ...

possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how to run a UPDATE statement to update data in a table in SQL ...

Several new features of Azure Synapse Analytics have just entered public preview, and for me the most interesting by far is the new SQL on-demand. In this post I am simply exploring several potential ...