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

Inga kommentarer: