Browse by Tags

• MDX
• PowerPivot
• SSAS

• 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: Read More... Posted Tuesday, October 28, 2014 6:12 PM by Marco Russo (SQLBI) | 13 Comments Filed under: SSAS, MDX, PowerPivot, Power Query, Power BI

• 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 Read More... Posted Tuesday, May 6, 2014 2:11 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Power Query, Power BI

• 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 Read More... Posted Monday, March 31, 2014 7:23 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Power Query, Power BI