Skip to content

Instantly share code, notes, and snippets.

Last active Apr 10, 2017
What would you like to do?
Exporting data out of Power Query into SQL Server via OleDb route
= OleDb.DataSource(
"provider=SQLOLEDB.1;data source=.;database=QueryPower",
[Query=Text.Format("INSERT INTO [dbo].[Demo] VALUES(#{0},'#{1}')",{1,"A"})])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment