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