Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

Last month I saw a puzzle posted on fivethirtyeight.com about poker hand probabilities and, like with many things these days, wondered how I could solve it with PowerBI.  I had been curious to learn more about the M list functions,… This post first appeared at https://powerpivotpro.com/2018/07/know-when-to-hold-em-part-i-fun-with-lists/. The author is Patrick MahoneyRead More

Read More

Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret. With relational data source like SQL Server you can […]

Read More

Level: Intermediate I do lots of live training, face to face and online, and I always encourage students to bring along any business problems they would like some help with.  Last week I had a great problem that Debbie shared with me that I thought was worth creating this blog article.  I have modified the […]

Read More

Lets start off with what is a table-valued function (TVF)? A TVF is a dynamic table produced at the time of execution, depending on parameters. Like a view, a TVF creates a result set only when it’s executed, but, unlike a view, it can be parameterized. You get two types of TVFs, an Inline Table-Valued […]

Read More

In today’s short post, I would like to share with you the Table of Contents of my book, Collect, Combine and Transform Data Using Power Query in Excel and Power BI. (You can pre-order the book on Amazon here or on Microsoft Press Store here). This post first appeared at https://datachant.com/2018/07/12/powerquery-book-table-of-contents/. The author is Gil RavivRead More

Read More

You’re Good at Power BI, but Underutilized, Bored, and/or Feeling Alone? Maybe We Can Fix All That. “You folks are the only office I would EVER go back to” This is one of my favorite recent quotes, and it came… This post first appeared at https://powerpivotpro.com/2018/07/why-havent-you-applied-for-a-power-bi-job-with-us/. The author is Rob CollieRead More

Read More

New capabilities for advanced data prep, enterprise-scale modeling and reporting. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-expands-self-service-prep-for-big-data-unifies-modern-and-enterprise-bi/. The author is Read More

Read More

Power BI gets a lot of love – and it deserves it.  But under the hood you will probably know that there are 2 technologies that are the true work horses that prepare the data for use.  Those 2 products are Power Query and Power Pivot.  Power Query is the data acquisition software that goes […]

Read More

Get a sneak peak of the Business Application Sumit content with a preview of one of the sessions Leila will be doing at the Business Applications Summit! This post first appeared at https://powerbi.microsoft.com/en-us/blog/7-12-webinar-text-analysis-in-power-bi-with-cognitive-services-with-leila-etaati/. The author is Read More

Read More

The month of June flew by quickly for Power BI. With summer in the air and MBAS just around the corner, we are laser focused on planning another unforgettable conference for you in Seattle! There… This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-june-2018-feature-summary/. The author is Read More

Read More

The Journey Begins I am an accountant fascinated with data. My PowerPivot journey started in 2013 when I encountered the PowerPivotPro blog while googling to find a way to tackle a multi-dimensional financial reporting task. Because of the limitations of… This post first appeared at https://powerpivotpro.com/2018/07/learning-the-magic-a-powerpivot-journey/. The author is Sakiko StickleyRead More

Read More

Level: Intermediate I wrote an article earlier this year that showed how you can take a table of future growth rates (different growth rates each year) and then calculate the future value of an investment using DAX.  I had a follow up question from Steve asking if it is possible to allow the user to […]

Read More

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve found on the internet work in more complex scenarios […]

Read More

Indexing can be quite confusing at times if you not 100% sure on what to do. Do you just index on key or do you add included columns? Well this depends on what you are doing and what type of performance improvement you are looking for. Lets start with some history, SQL Server 2005 added […]

Read More

Intro How did I come to PowerPivot and the related tools? Desperation in trying to fix a process problem. How did I get to the point where I can return a reasonable answer to a data query using the Power… This post first appeared at https://powerpivotpro.com/2018/07/creating-the-right-measures-a-power-pivot-journey/. The author is Gordon FullerRead More

Read More

Following on from my post the other week about the new RowsetSerializationLimit server property, I thought it would be a good idea to write about why the new IsAvailableInMDX property (announced in the same blog post) is so important. In fact, I would say that everyone using Analysis Services Tabular 2017 (CU7 or higher) or […]

Read More

Matt Here:  I first met Ivan via Twitter when he was living in Russia, and then in person when he moved to Australia to live in Sydney with his family. Ivan is a talented Power BI professional and I have learnt many things from him over the last few years.  Today Ivan is writing a […]

Read More

This blog post covers the latest updates for Power BI Developers community- Power BI Embedded and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-june-update/. The author is Read More

Read More

I was excited and humbled tonight to receive this special email from Microsoft: Dear Gil Raviv, This post first appeared at https://datachant.com/2018/07/01/microsoft-mvp-award-2018-2019/. The author is Gil RavivRead More

Read More

We are happy to announce that we have just released the June update for the On-premises data gateway.   This month’s Gateway update includes an updated version of the Mashup Engine, which… This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-update-is-now-available/. The author is Read More

Read More