måndag 13 oktober 2014
Power Query: SQL-server query based on an Excel table
My first trial to query a SQL-database via an Excel list:
let
Source1 = Excel.CurrentWorkbook(){[Name="Table8"]}[Content],
Source2 = Sql.Database("MS10\SQLEXPRESS", "TSQL2012"),
Sales_CustOrders = Source2{[Schema="Sales",Item="CustOrders"]}[Data],
Joined = Table.Join(Source1, "custid", Sales_CustOrders, "custid"),
in
Joined
Unpublished: Import Pictures, Book: Power Query for Power BI and Excel
Similar posts: dynamic filters, dynamic function, FastCombine
Videos:
Deep Dive into Power Query Formula Language
The Power Query Formula Language, PowerPivot video
Prenumerera på:
Kommentarer till inlägget (Atom)
Inga kommentarer:
Skicka en kommentar