Can You Use Power Query In Power BI Or Excel To Write Data To A Data Source?

It is, technically, 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 Server.

Bron : Chris Webb’s BI Blog
Lees meer…