THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Power Query   (RSS)
  • Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

    The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the Power Query window. Consider the following table in Excel: You want to obtain a table containing the number of distinct products bought ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 31, 2014
  • Power Query now imports relationships #powerquery #powerpivot

    The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the data model as well. This is similar to the behavior you have in Power Pivot, but there is an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 17, 2013
  • Declarative ETL

    T-SQL is a declarative programming language. This means that a T-SQL developer defines what (s)he wants the query to do, not how to do it. The secret sauce that turns the “what” into the “how” is a piece of software called the query optimiser and there are tomes dedicated to how one can make the query optimiser dance to their will. Generally the ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 16, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement