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)
  • Power Query support for Analysis Services (MDX)

    Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown:It should be able to query both Multidimensional and TabularGenerates query in MDX (no DAX by ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2014
  • Power Query in Modern Corporate BI–Copenhagen, June 3, 2014–#powerquery

    I will be in Copenhagen to deliver the SSAS Tabular Workshop on June 2-4, 2014 (few seats still available, but hurry up!). In the same week I will be a speaker in an evening community event, MsBIP møde nr. 21, delivering the Power Query in Modern Corporate BI session that I also presented at TechEd North America 2014 last week. It’s not just a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 19, 2014
  • First steps with Scheduled Data Refresh for Power Query #powerbi #powerquery

    Just a few days before my session about Power Query at TechEd 2014, Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations. This is a very good news, because it enables the data refresh of a number of different data sources. Even if the number of providers supported ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 6, 2014
  • 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