Browse by Tags

• DAX
• Excel 2013
• MDX
• Power BI
• PowerPivot
• SSAS
• Tabular

• Power Query now connects to Analysis Services #ssas #mdx #dax

  The last update of Power Query finally supports Analysis Services Multidimensional and Tabular. I waited this version for a very long time, but now it's finally here! Chris Webb already wrote an interesting blog post with several useful link and informations. Read More... Posted Wednesday, November 26, 2014 10:20 AM by Marco Russo (SQLBI) | 3 Comments Filed under: DAX, MDX, Power Query, SSAS, Tabular

• 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: MDX, Power BI, Power Query, PowerPivot, SSAS

• 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 Read More... Posted Monday, May 19, 2014 11:47 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Power Query

• 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 BI, Power Query

• 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 BI, Power Query

• 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 Read More... Posted Tuesday, December 17, 2013 3:42 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Excel 2013, Power Query, PowerPivot