Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active April 10, 2017 09:52
Embed
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