Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

«December 2015»

T-SQL Tuesday #73 Invitation – Naughty or Nice?

Hello Dear Reader!  This is the first Tuesday of the month and you know what that means.  It’s time to announce the T-SQL Tuesday Topic of the month!  This is your opportunity to participate in the largest SQL Blog party on the intrawebs. 

T-SQL Tuesday is an event started by Adam Machanic(@AdamMachanic| Blog) back in 2009.  The basic idea one blogger hosts the party and others participate.  We announce the topic the first Tuesday of the month, December 1st 2015 for today, and everyone will post their blogs on the second Tuesday of the month, December 8th 2015 for the actual posts.  This month the host is none other than……….. drum roll………….. ME!

Read more

Thoughts on December 2013 Power Query Updates

  • 11 December 2013
  • Author: DevinKnight
  • Number of views: 2426

Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates.  The list of updates can be found here but for my notes specifically on Power Query updates continue reading!

Power Query

Power Query now has 3 new data sources that you can connect to.  Connectors have now been added for Sybase IQ, Exchange and Dynamics CRM Online.  Sybase IQ is the column-store database technology produced by SAP and is used for many organizations for BI solutions.  This is a great add for Microsoft to pull in competitors data sources. The addition of Exchange was a bit of a surprise to me at first but once I saw my first demo connecting to an Exchange email account I was pretty impressed what you could do with it.  Expect a blog post on this one soon.  Last, Dynamic CRM Online is likely to be very interesting to many organizations.  My company uses Dynamics and having the ability to easily pull data from it into a self service solution is a huge win.

Power Query can now automatically detects database relationships.  This functionality has existed in other Microsoft technologies including Power Pivot but now is available in Power Query too.

In the November release of Power Query the Query Editor ribbon was introduced.  Now the Query Editor ribbon has additional buttons for Fill Down, Sort Ascending/Descending and Number Transformations. The Fill Down function is a really cool M query function that I demoed in this whitepaper.

In addition to these, several new features have been added in regards to sharing organizational queries:

  • The Replace Shared query has been removed.
  • You can now Share your query from the Query fly-out
  • A new Certified button was added to the Search ribbon, enabling Search result to only show Certified results. 
Rate this article:
No rating


Other posts by DevinKnight

Please login or register to post comments.