Browse by Tags

• Excel 2013
• Power BI
• PowerPivot

• 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 06, 2014 2:11 PM by Marco Russo (SQLBI) | 2 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) | 5 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