THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Power Query » Power BI   (RSS)
  • Analysing SQLBlog using Power Query

    In December 2011 I wrote a blog post entitled Querying RSS feed subscriber count on Google Reader using Data Explorer‏ in which I used a product called Data Explorer, that was in beta at the time, to find out how many people subscribed on Google Reader to various bloggers on Here were the results: It was a nice demo of ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 25, 2015
  • 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 Tabular Generates query in MDX (no ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement