Select Page

In The Trenches

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

There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the years. When I joined Microsoft last month I came across one […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/crXVjy9sjXU/. The author is Chris Webb

Read More

Read More

This month we are incredibly excited to announce that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality. The new capabilities include a new filter view to see what filters are applied to a visual, the ability to format or theme the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-filter-experience-for-power-bi-reports/. The author is 

Read More

Read More

Today Microsoft announced that it is now supporting icon sets to be used for conditional formatting in Power BI.  This feature has been available in Excel, like forever, and it great to see it available … Conditional Formatting Using Icons In Power BI Read More This post first appeared at https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/. The author is Matt Allington

Read More

Read More

Introducing a tool for accurate load testing of premium capacities This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-know-what-your-premium-capacity-can-handle/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-know-what-your-premium-capacity-can-handle/. The author is 

Read More

Read More

The volume of data is growing at an ever-increasing rate. As it grows, so does the value to the companies that are able to unlock insights from it. Power BI is all about helping organizations embrace a data culture, where every user can make better decisions based on data big and small, no matter where […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/aggregations-for-petabyte-scale-bi-is-generally-available/. The author is 

Read More

Read More

With this month comes the first feature release from our announcements at Microsoft Business Application Summit, Icon sets, which also addresses our current #1 idea on ideas.powerbi.com. On top of this major update, we have incremental improvements for many of our existing features, such as measure support for the Key influencers visual and RLS support […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/. The author is 

Read More

Read More

New gateway management features on Admin center This post first appeared at https://powerbi.microsoft.com/en-us/blog/gateway-management-on-admin-center/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/gateway-management-on-admin-center/. The author is 

Read More

Read More

Follow @gilra In Chapter 11 of my book, I introduced the Cartesian Product technique that enables you to combine two datasets in order to apply a calculation or filtering on each combination of paired records. In this article, you will learn how to apply this technique to find overlapping time periods. This post first appeared […]

This post first appeared at https://datachant.com/2019/07/16/find-overlapping-time-periods-using-powerquery/. The author is Gil Raviv

Read More

Read More

A Power BI Technique Mined from the Power Pivot Archives Below, you will find one of our all-time favorite Power BI techniques. In the ten (yes ten) years we’ve been operating this site, we’ve written over 1,000 articles on Power… This post first appeared at https://powerpivotpro.com/2019/07/filter-when-why-how-to-use-it/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/07/filter-when-why-how-to-use-it/. The author is Rob Collie

Read More

Read More

If you’ve ever built a BI solution it’s likely you will have had to integrate third party data, and if that’s the case you will know how painful it often is to get your hands on that data. Badly designed portals you have to log into every week to download the data, CSV files emailed […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/MSZkZapi7nk/. The author is Chris Webb

Read More

Read More

June was yet another exciting month for Power BI! Read on for a summary of the announcements we made in both the service and mobile. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-june-2019-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-june-2019-feature-summary/. The author is 

Read More

Read More

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presumption that a relatively … Pareto Analysis in Power BI Read More This post first appeared at https://exceleratorbi.com.au/intermediate/pareto-analysis-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/intermediate/pareto-analysis-in-power-bi/. The author is Matt Allington

Read More

Read More

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presumption that a relatively small number of inputs (20%)  have most impact on the results/output (80%).  The 80:20 rule can be applied to a […]

This post first appeared at https://exceleratorbi.com.au/pareto-analysis-in-power-bi/. The author is Matt Allington

Read More

Read More

The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While there’s a good reason for this it can nevertheless be mildly confusing for developers and end users alike […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/wK_WMGBKIto/. The author is Chris Webb

Read More

Read More

A Power BI Technique Mined from the Power Pivot Archives Below, you will find one of our all-time favorite Power BI techniques. In the ten (yes ten) years we’ve been operating this site, we’ve written over 1,000 articles on Power… This post first appeared at https://powerpivotpro.com/2019/07/sumx-the-5-point-palm-exploding-fxn-technique/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/07/sumx-the-5-point-palm-exploding-fxn-technique/. The author is Rob Collie

Read More

Read More

This outlines the new features for July gateway release. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-july-2019-update-is-now-available/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-july-2019-update-is-now-available/. The author is 

Read More

Read More

Announcing support for sending refresh failure notifications to others in addition to the dataset owner. This feature enables dataset owners to monitor data refreshes more reliably and more effortlessly than before. It can help to ensure refresh issues get noticed and addressed in a timely manner. This post first appeared at https://powerbi.microsoft.com/en-us/blog/sending-refresh-notifications-to-others/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/sending-refresh-notifications-to-others/. The author is 

Read More

Read More

Last week I was re-awarded as a Microsoft MVP (This is the third year now) and I am so grateful. The Microsoft Most Valuable Professional award is a unique program (Learn more about the program here). Being MVP has opened so many opportunities for me and allowed me to meet and collaborate with amazing people […]

This post first appeared at https://datachant.com/2019/07/07/my-mvp-2019-2020-award/. The author is Gil Raviv

Read More

Read More

Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules. For example, say you have a table with the following data in it: …and you want to highlight the rows where […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/xtMYtWORFJg/. The author is Chris Webb

Read More

Read More

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points.  I thought it was pretty cool, so decided to see if I … Slicer with Histogram in Power BI Read More This post first appeared at https://exceleratorbi.com.au/intermediate/slicer-with-histogram-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/intermediate/slicer-with-histogram-in-power-bi/. The author is Matt Allington

Read More

Read More

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll